Re: Fw: OID

From: "Jules Alberts" <jules(dot)alberts(at)arbodienst-limburg(dot)nl>
To: Postgres Admin List <pgsql-admin(at)postgresql(dot)org>
Cc: Postgres Admin List <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Fw: OID
Date: 2002-08-19 07:10:08
Message-ID: 200208190712.g7J7BxSN030705@artemis.cuci.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On 16 Aug 2002 at 13:40, Joe Conway wrote:
> Jodi Kanter wrote:
> > Does anyone have a comment on the email below? Is there a general
> > consensus on whether or not to use OIDs with version 7.2?
>
> <snip>
>
> >
> > Can anyone point me to some documentation on the use of OIDs? Why
> > might I need them? How to remove them in version 7.2? ..etc...
>
> I think you're best to avoid using them. They are primarily for internal
> system use. If you need an incrementing integer field, create your own
> with SERIAL, or integer field and a sequence.

Is there any consensus aboit avoiding OIDs? I'm running a small test
system right now using OIDs as a means to refer to BLOBs. Should I
expect any trouble using OIDs in our future production system?

TIA!

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message calvin 2002-08-19 09:02:56 Re: J2EE with PostgreSQL
Previous Message Daniel L Banta 2002-08-18 17:24:15 Re: Fw: OID