Re: [Gusdev-gusdev] Porting to PostgreSQL

[Steve F. <sfi...@pc...>]

Jason-

Here is a quote from a mail i sent on Feb 13:

----------------------------------------------------------------------------------
Porting the Object Layer
I just did a quick look in the object layer code (Perl).  (we can defer 
for now on the java object layer since its not in wide use).   Only two 
files seem to use oracle system tables, both in 
$PROJECT_HOME/GUS/ObjRelP/lib/perl:  DbiTable.pm and DbiDatabase.pm.   
There are about 10 separate sql queries that use the oracle system 
tables (listed below).   A quick fix would be to supply an Oracle.pm and 
a PostgreSQL.pm which have methods that provide the correct sql for 
those queries.   IF postgres has parallel tables, then this should be 
trivial.  if not...?    here are the tables used:

all_sequences
all_cons_columns
all_constraints
all_tab_columns
all_views
----------------------------------------------------------------------------------

I know that Laurie was working on porting the queries found in the 
object layer, and seems to have succeeded.

I suggested that we  factor those queries out of the DbiTable.pm and 
DbiDatabase.pm files, and place them into an Oracle.pm and PostgreSQL.pm.

How did you guys integrate the PostgreSQL specific queries into the 
object layer?

If you haven't done a clean refactoring we can work together on that...

steve

Jason Hackney wrote:

> Hi Chris,
>
> Well, I wouldn't be so fast to do that just yet. As of this morning, I 
> have rebuilt Pg 7.3, and reinstalled GUS. Everything builds fine, 
> including the array and associated tables, as far as I can tell. I can 
> register plugins using ga. That's about it, so far. What I think would 
> be useful would be some examples of Perl modules built using Oracle, 
> just so I can make sure that everything is kosher. Anyone want to 
> volunteer a couple of modules they have built, so I can compare and 
> contrast? So far, so good, though.
>
> Cheers,
> Jason
>
> On Mar 9, 2004, at 8:06 AM, Chris Stoeckert wrote:
>
>> Hi Jason,
>> Great to hear of your progress. Sounds like we will need to change 
>> the table name for Array in RAD.
>>
>> Any suggestions? "Array_" "ArrayP" (for ArraryPostgreSQL)
>>
>> Chris
>>
>> On Mar 8, 2004, at 7:04 PM, Jason Hackney wrote:
>>
>>> Hi all,
>>>
>>> I am working with Laurie Kramer to port the GUS platform to 
>>> PostgreSQL. Most things work, or are pretty trivial to get working 
>>> (more on that later). The only real issue I have run into is 
>>> PostgreSQL uses array as a reserved word (it's a datatype), and you 
>>> can't make a table called array. This is as of PostgreSQL 7.4 (and 
>>> is a keyword according to SQL99). PostgreSQL 7.3 doesn't reserve 
>>> this word, but is a bit gimpy on sub-selects, if necessary we can 
>>> downgrade, but this will be an issue in the future, as 7.3 departs 
>>> and 7.4 takes over for it.
>>>
>>> Cheers,
>>> Jason
>>>
>>> Jason A. Hackney
>>> Graduate Student
>>> Princeton University
>>>
>>>
>>>
>>> -------------------------------------------------------
>>> This SF.Net email is sponsored by: IBM Linux Tutorials
>>> Free Linux tutorial presented by Daniel Robbins, President and CEO of
>>> GenToo technologies. Learn everything from fundamentals to system
>>> administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
>>> _______________________________________________
>>> Gusdev-gusdev mailing list
>>> Gus...@li...
>>> https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
>>>
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: IBM Linux Tutorials
> Free Linux tutorial presented by Daniel Robbins, President and CEO of
> GenToo technologies. Learn everything from fundamentals to system
> administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
> _______________________________________________
> Gusdev-gusdev mailing list
> Gus...@li...
> https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev