Re: Fw: OID - Mailing list pgsql-admin

From Curt Sampson
Subject Re: Fw: OID
Date
Msg-id Pine.NEB.4.44.0208192349320.432-100000@angelic.cynic.net
Whole thread Raw
In response to Re: Fw: OID  ("Jules Alberts" <jules.alberts@arbodienst-limburg.nl>)
Responses Re: Fw: OID  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
On Mon, 19 Aug 2002, Jules Alberts wrote:

> 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?

I don't know if there's a consensus, but I certainly avoid using OIDs
completely in my own tables. They're can wrap, for a start, so in a
really busy, large database you might end up getting one that you
already have. Also, I don't like "hidden" fields; if I'm going to refer
to soemething, I like it to be nice and obvious what's being referred
to. And of course they're not portable.

cjs
--
Curt Sampson  <cjs@cynic.net>   +81 90 7737 2974   http://www.netbsd.org
    Don't you know, in this new Dark Age, we're all light.  --XTC


pgsql-admin by date:

Previous
From: "Jules Alberts"
Date:
Subject: Re: Fw: OID
Next
From: Tom Lane
Date:
Subject: Re: Fw: OID