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

From Johnson, Bruce E - (bjohnson)
Subject Re: [EXT]Re: Strange error trying to import with Ora2PG
Date
Msg-id BCFF6FA8-9D61-4D7F-8D0D-C2BAD30691E8@arizona.edu
Whole thread Raw
In response to Re: [EXT]Re: Strange error trying to import with Ora2PG  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general


On Oct 4, 2023, at 8:38 AM, Adrian Klaver <adrian.klaver@aklaver.com> 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. Clearly the script is running the other one. 

~/oracle_migration$ tree calendar3

calendar3

├── config

│   ├── ora2pg.conf

│   └── ora2pg.conf.orig


SNIP


├── schema

│   ├── dblinks

│   


SNIP


│   └── views

│       ├── AHSC_SCHEDULE_ROUNDED_view.sql

│       ├── COP_COLLEGE_HOUR_view.sql

│       ├── RESERVER_VISIBLE_RESTRICTION_view.sql

│       ├── RESOURCEAFFIL_WITHCODE_view.sql

│       ├── UA_COLLEGE_LOOKUP_view.sql

│       └── view.sql

└── sources

   

SNIP


    └── views

        ├── AHSC_SCHEDULE_ROUNDED_view.sql

        ├── COP_COLLEGE_HOUR_view.sql

        ├── RESERVER_VISIBLE_RESTRICTION_view.sql

        ├── RESOURCEAFFIL_WITHCODE_view.sql

        ├── UA_COLLEGE_LOOKUP_view.sql

        └── view.sql


29 directories, 127 files



-- 
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group

Institutions do not have opinions, merely customs


pgsql-general by date:

Previous
From: Lincoln Swaine-Moore
Date:
Subject: Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones
Next
From: jinser
Date:
Subject: I'm using both window and agg, is this expected sorting behavior?