From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | "Johnson, Bruce E - (bjohnson)" <Johnson(at)pharmacy(dot)arizona(dot)edu>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Strange error trying to import with Ora2PG |
Date: | 2023-10-03 21:27:44 |
Message-ID: | 7ef07a8e-57bc-4b72-8e69-2b1649fdcf34@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 the same error (in fact the pasted error code is from running
> the script AFTER I fixed it). The sql isn’t being cached anywhere in the
> system is it?
I'm betting that every time you run import_all.sh it rewrites the
scripts. Pretty sure if you look at the file the creation script will
have been rewritten to its original from.
>
> I know that I modified the correct file.
>
> It happens even if I drop the database and recreate it.
>
> --
> Bruce Johnson
> University of Arizona
> College of Pharmacy
> Information Technology Group
>
> Institutions do not have opinions, merely customs
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Lincoln Swaine-Moore | 2023-10-04 02:32:48 | Strategies for converting UTC data to local windows for arbitrary resolutions and timezones |
Previous Message | Johnson, Bruce E - (bjohnson) | 2023-10-03 17:32:31 | Strange error trying to import with Ora2PG |