search

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
1.01k stars 342 forks source link

ERROR: argument of AND must be type boolean, not type integer #1596

Closed leutenmayr closed 1 year ago

leutenmayr commented 1 year ago

Hi,

I am trying to migrate from Oracle to Postgres. During the execution of the TABLE_ora2pgoutput.sql file, I get the following error: ERROR: argument of AND must be type boolean, not type integer

the line in question is: ALTER TABLE abc ADD CONSTRAINT abc_check CHECK ((role_id AND role_id::text <> '') OR (field_id AND field_id::text <> ''));

Is this something I would have to correct manually in the generated sql file or is it a generation error?

Thanks and best regards

Stephan

leutenmayr commented 1 year ago

I manually corrected the lines in question..