[AuckLUG] PostgreSQ 8 OID not working

[David Hawke]

John O'Gorman wrote:
> Anyone know if/why postgresql version 8 seems to no longer support the
> OID expression?
>
> select oid, * from <tablename>;  produces ERROR: column "oid" does not
> exist.
>
> Same goes for OID, ROWID, rowid, and anything else I could think of.
>   

>From memory, the database or the table has to be set up to allow
selection of oid's - think its an option on one of the pgadmin forms

Sorry - a little imprecise - don't have a pgadmin handy to look at

DavidH
> Strangely the other postgres stuff: tableoid, cmin, cmax, xmin, xmax,
> ctid all still work as expected.
>
> I'd be grateful for any clues, suggestions, fixes, ...
>
> I'm running it under openSUSE 10.2
>
> regards
> John O'Gorman
>
>
> _______________________________________________
> AuckLUG mailing list
> AuckLUG at linux.net.nz
> http://www.linux.net.nz/cgi-bin/mailman/listinfo/aucklug
>