Обсуждение: problems with postgresql 9

Поиск
Список
Период
Сортировка

problems with postgresql 9

От
"romeo midhun"
Дата:

 
hi friends,

Why the 'oid' column reference doesn't work with postgresql 9.x?

Re: problems with postgresql 9

От
Alban Hertroys
Дата:
romeo midhun wrote:
>
> hi friends,
>
> Why the 'oid' column reference doesn't work with postgresql 9.x?

Hiya, time traveller. You ended up in the wrong year; PostgreSQL 9
doesn't exist yet.

--
Alban Hertroys
alban@magproductions.nl

magproductions b.v.

T: ++31(0)534346874
F: ++31(0)534346876
M:
I: www.magproductions.nl
A: Postbus 416
    7500 AK Enschede

// Integrate Your World //

Re: problems with postgresql 9

От
"A. Kretschmer"
Дата:
am  16.05.2006, um 11:18:09 +0200 mailte Alban Hertroys folgendes:
> romeo midhun wrote:
> > hi friends,
> >Why the 'oid' column reference doesn't work with postgresql 9.x?
>
> Hiya, time traveller. You ended up in the wrong year; PostgreSQL 9 doesn't
> exist yet.

;-)

Btw.: if you need the oid, you should create the tables with oid. Read
the release notes, oid is not by default. (since 8.0 or 8.1, i don't
know)


HTH, Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47215,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===

Re: problems with postgresql 9

От
"Jim C. Nasby"
Дата:
On Tue, May 16, 2006 at 11:24:38AM +0200, A. Kretschmer wrote:
> am  16.05.2006, um 11:18:09 +0200 mailte Alban Hertroys folgendes:
> > romeo midhun wrote:
> > > hi friends,
> > >Why the 'oid' column reference doesn't work with postgresql 9.x?
> >
> > Hiya, time traveller. You ended up in the wrong year; PostgreSQL 9 doesn't
> > exist yet.
>
> ;-)
>
> Btw.: if you need the oid, you should create the tables with oid. Read
> the release notes, oid is not by default. (since 8.0 or 8.1, i don't
> know)

And if you do think you need OID, you should probably be asking yourself
why, as it's been recommended not to use it since around 7.4.
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461