[AuckLUG] PostgreSQ 8 OID not working

[Ravi Chemudugunta]

On 5/29/07, Ravi Chemudugunta <chemuduguntar at gmail.com> wrote:
>
> On 5/29/07, Ravi Chemudugunta <chemuduguntar at gmail.com> wrote:
> >
> > 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
> > >
> >
> >
> sorry about the tofu posting...not used to gmail leaving cursor at the top
>

actually thats a lie there ... every mail client does that, crap now i am
spamming!