[Gusdev-gusdev] Porting to PostgreSQL

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

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