Remove trailing ); from primary key statements when reading from file

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

Remove trailing ); from primary key statements when reading from file #1705

Closed marty-se closed 8 months ago

marty-se commented 8 months ago

The issue before this change was that primary key DDL output when reading from file became: ALTER TABLE tbl ADD PRIMARY KEY pk_tbl (tblid));;

After this change:

ALTER TABLE tbl ADD PRIMARY KEY pk_tbl (tblid);

Not sure if it's the correct solution, feel free to modify as appropriate.

darold commented 8 months ago

Thanks!