Some COPY statements are not converted

Question

Some COPY statements are not converted

Opened this issue 3 years ago · 4 comments

I tried to convert a multi-schema dump, but there are unconverted COPY statements in between. Here is an example of the original dump:

And here is the result of dump2insert on the same section of the file:

As you can see, the latter is remained intact.

Answer 1 · 2022-03-07T09:41:21.000Z

What non-alphabetic characters do you have in second schema ?

Answer 2 · 2022-03-07T09:50:35.000Z

There are numbers, dots, colons, single-quotes, etc. However, I'm suspicious of the 3rd column name, since it's wrapped in double-quotes due to belonging to reserved names.

Answer 3 · 2022-03-07T10:10:51.000Z

I've made corrections in the regexp. Could you check by your side with last master commit ?

Answer 4 · 2022-03-07T10:32:00.000Z

Yup, it works fine now. Thanks for your quick response & patch.