Re: [EXT]Re: Strange error trying to import with Ora2PG

2023-10-04 Thread Johnson, Bruce E - (bjohnson)
On Oct 4, 2023, at 8:38 AM, Adrian Klaver wrote: If you search the source file directory for "reserver_visible_restriction" is there another file that contains it? Sigh…that was it…Thank you. There are two ‘views’ directories, one under ’sources/views’ and the other under /schema/views.

Re: [EXT]Re: Strange error trying to import with Ora2PG

2023-10-04 Thread Johnson, Bruce E - (bjohnson)
That’s not it. export_schema.sh writes the scripts, and then emits a ora2pg command to pull in the data (I've managed to do this a dozen times so far working out how to do things. :-) The dates on the files in the sources directory are consistent with that, and don’t change when I run the scrip

Re: [EXT]Re: Strange error trying to import with Ora2PG

2023-10-04 Thread Adrian Klaver
On 10/4/23 06:24, Johnson, Bruce E - (bjohnson) wrote: That’s not it. export_schema.sh writes the scripts, and then emits a ora2pg command to pull in the data (I've managed to do this a dozen times so far working out how to do things. :-) The dates on the files in the sources directory are con

Re: Strange error trying to import with Ora2PG

2023-10-03 Thread Adrian Klaver
On 10/3/23 10:32, Johnson, Bruce E - (bjohnson) wrote: I am trying to import an oracle schema with ora2pg and running into an odd error when the import_all.sh script gets to a specific view. The error is: However when I re-run the import_all.sh script it errors out at the same place with th

Strange error trying to import with Ora2PG

2023-10-03 Thread Johnson, Bruce E - (bjohnson)
I am trying to import an oracle schema with ora2pg and running into an odd error when the import_all.sh script gets to a specific view. The error is: psql:schema/views/RESERVER_VISIBLE_RESTRICTION_view.sql:10: ERROR: operator does not exist: character = integer LINE 1: ...r.resource_id = rg.re