Re: Strange error trying to import with Ora2PG - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Strange error trying to import with Ora2PG
Date
Msg-id 7ef07a8e-57bc-4b72-8e69-2b1649fdcf34@aklaver.com
Whole thread Raw
In response to Strange error trying to import with Ora2PG  ("Johnson, Bruce E - (bjohnson)" <Johnson@pharmacy.arizona.edu>)
Responses Re: [EXT]Re: Strange error trying to import with Ora2PG
List 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.klaver@aklaver.com




pgsql-general by date:

Previous
From: "Johnson, Bruce E - (bjohnson)"
Date:
Subject: Strange error trying to import with Ora2PG
Next
From: Lincoln Swaine-Moore
Date:
Subject: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones