Postgres Pro
Downloads
Home   >   mailing lists

Thread: History of oids in postgres?

History of oids in postgres?

From
James Robinson
Date:
Bruno et al,

    Any self-repsecting lurker would know that oids as row identifiers are
depreciated in postgres. Can anyone provide a brief history regarding
the reasoning behind using them as row identifiers in the first place?
I see a discussion of their use as various primary keys in he system
catalog in the oid-datatype doc page, but not regarding their history
as 'user-space' row ids.

Thanks,
James

----
James Robinson
Socialserve.com

Re: History of oids in postgres?

From
Bruce Momjian
Date:
James Robinson wrote:
> Bruno et al,
>
>     Any self-repsecting lurker would know that oids as row identifiers are
> depreciated in postgres. Can anyone provide a brief history regarding
> the reasoning behind using them as row identifiers in the first place?
> I see a discussion of their use as various primary keys in he system
> catalog in the oid-datatype doc page, but not regarding their history
> as 'user-space' row ids.

They were added at Berkeley and I think are related to the
Object-relational ability of PostgreSQL.  I think the newer SQL
standards have a similar capability specified.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073