Error in special names (columns, tables)

[mkgrgis]

Oracle 12, UTF-8
Postgresql 14, UTF-8
ora2pg 23.2
PRESERVE_CASE 1

Oracle
A tables with special signs or/and with "." in names or names of column translated to PostgreSQL not correct.

CREATE TABLE "TECHEXPRO"."⚙ parametres" ("Id" int, "Class1.p0" number(9,3), "Class1.p1" number(9,3), "Class2.p0" number(9,3), "Class2.p1" number(9,3), "Class2.p3" number(9,3), "Class3.p0" number(9,3) )

For example "Class1.p0" have translated to "Class1"."p0". It seems ⚙ haven't correct translated at all.

[darold]

Ora2Pg do not support dot in object name. This is something I have never encountered and might be very rare so I have not spend time on this until now and will not for the moment.

[mkgrgis]

Thanks, @darold! Let's dot in names will be enhancement. If there is hard regular expressions, maybe https://www.debuggex.com can help you.

[darold]

@mkgrgis I think that this link https://docs.github.com/en/pull-requests/collaborating-with-pull-requests/proposing-changes-to-your-work-with-pull-requests/creating-a-pull-request could help more to have this enhancement.

[mkgrgis]

Thanks @darold !

I am studying Perl (after JavaScript and C experience) and have some URLs of closed issues with problems with object names. Hence some "key lines" are visible for me. I think this will enough to draft, testing and PR to your mainstream. I am beginning from 7f74071 and e927080

Thanks for many years of developing of this usefully open source utility!

[darold]

Ora2Pg rename all columns with a dot in the name by replacing them with underscore. The new name is appended to the REPLACE_COLS configuration directive value.