Closing quotation mark missing for index creation on reserved keyword

darold / ora2pg

Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema. It connects your Oracle database, scan it automatically and extracts its structure or data, it then generates SQL scripts that you can load into PostgreSQL.

http://www.ora2pg.com/

GNU General Public License v3.0

978 stars 341 forks source link

Closing quotation mark missing for index creation on reserved keyword #1771

Closed moonbeamglitterblossom closed 2 months ago

moonbeamglitterblossom commented 2 months ago

I'm migrating an oracle table with reserved keywords, one of them being end. When I run the export_schema.sh script for some reason the closing quotation mark is dropped in the create index statement causing import_all.sh to fail: CREATE INDEX i_x_end ON x ("end);

Relevant config settings:

USE_RESERVED_WORDS  1
FILE_PER_INDEX          0

darold commented 2 months ago

Do you have the Oracle DDL to create this index?

darold commented 2 months ago

Commit 58944ae fixes this issue.