[BioSQL-l] PostgreSQL Error: column "oid" does not exist

[Roy Chaudhuri]

Hi all.

I've just been playing around with a new install of PostgreSQL v8.14. I 
was getting lots of error messages saying 'column "oid" does not exist' 
when I loaded the BioSQL schema (biosqldb-pg.sql). After a bit of 
research I found out that the default value for default_with_oids has 
changed from true to false for PostgreSQL 8.1 onwards:
http://www.postgresql.org/docs/8.1/static/runtime-config-compatible.html#GUC-DEFAULT-WITH-OIDS

Altering the BioSQL table definitions to explicitly state 'WITH OIDS' 
before the semicolon works as a fix. Perhaps this could be changed in 
the CVS?

Sorry if this seems obvious to Pg experts but it would have saved a 
novice like me a bit of time had I found mention of it in the mailing 
list archives.

Cheers,
Roy.

--
Dr. Roy Chaudhuri
Bioinformatics Research Fellow
Division of Immunity and Infection
University of Birmingham, U.K.

http://xbase.bham.ac.uk