Re: [Gusdev-gusdev] Porting to PostgreSQL

[Angel P. <an...@pc...>]

Actually, The Array table is an "ArrayDesign" object in MAGE. Why not 
just name it that?

Angel
Steve Fischer wrote:

> I think we need to find a name that is appropriate across all 
> platforms, and is self-explanatory. 
> we just need to find a prefix which captures the full generality of 
> the Array as we are using it.
>
> how about:
>  MicroArray
>  BioArray
>  ExpressionArray
>  HybridizationArray
>
> steve
>
> 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
>
>