[AuckLUG] PostgreSQ 8 OID not working

[Ravi Chemudugunta]

I guess this is because most people didn't use object-relational features
available ?
On 5/29/07, John O'Gorman <john at og.co.nz> wrote:
>
> On Tue, 2007-05-29 at 10:34 +1200, David Hawke wrote:
> > 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
> >
> Found it!
> With version 8.1 the default configuration of postgres has changed from
> default_with_oids being on to off. They deprecate the use of oids.
> To get them, you now have to either CREATE the table with OIDS or change
> the value of the default_with_oids to true.
>
> thanks
> John O'Gorman
> > 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
> > >
> >
> >
> > _______________________________________________
> > AuckLUG mailing list
> > AuckLUG at linux.net.nz
> > http://www.linux.net.nz/cgi-bin/mailman/listinfo/aucklug
> >
>
>
> _______________________________________________
> AuckLUG mailing list
> AuckLUG at linux.net.nz
> http://www.linux.net.nz/cgi-bin/mailman/listinfo/aucklug
>