Re: oid's and primary keys on insert - Mailing list pgsql-general

From Curt Sampson
Subject Re: oid's and primary keys on insert
Date
Msg-id Pine.NEB.4.44.0208121226130.2317-100000@angelic.cynic.net
Whole thread Raw
In response to Re: oid's and primary keys on insert  (Jean-Luc Lachance <jllachan@nsd.ca>)
Responses Re: oid's and primary keys on insert  (Neil Conway <nconway@klamath.dyndns.org>)
List pgsql-general
On Fri, 9 Aug 2002, Jean-Luc Lachance wrote:

> Joe Conway wrote:
>
> We could have one sequence of OID (4 bytes) per table and a prefix (4
> bytes) for a specific table in the system table.  So we could have an
> effective OID of 8 bytes and still keep the benefit of system wide
> unique OID.

Or we could just create an explicit "object ID" column in those system
tables that need it, and drop the whole object IDs thing entirely. Then
all this confusion over the purpose of object IDs would go away.

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-general by date:

Previous
From: Curt Sampson
Date:
Subject: Re: oid's and primary keys on insert
Next
From: Randall Perry
Date:
Subject: Craetalang function can't find libgcc_s.so.1 on Solaris 8