Re: [Gusdev-gusdev] Porting to PostgreSQL

[Jason H. <jha...@pr...>]

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
>>