Re: [Gusdev-gusdev] Porting to PostgreSQL

[Chris S. <sto...@pc...>]

OK. I like the idea of changing the name from Array to ArrayDesign. 
Your getting going in Pg 7.3 gives us time to plan this transition 
gracefully.
Chris

On Mar 9, 2004, at 10:18 AM, 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
>