Re: How to implement an auto-increment column for a system catalog table? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: How to implement an auto-increment column for a system catalog table?
Date
Msg-id 16139.1237207211@sss.pgh.pa.us
Whole thread Raw
In response to Re: How to implement an auto-increment column for a system catalog table?  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
Simon Riggs <simon@2ndQuadrant.com> writes:
> On Mon, 2009-03-16 at 10:18 +0800, Xin Wang wrote:
>> I am using Postgres to build the prototype in a research project. I need
>> to create a new system catalog table with an auto-increment column.

> Other catalog tables use a new oid for each new row/entry. Just do it in
> the code for adding each new entry. Look at backend/catalog/heap.c
> heap_create_with_catalog(), or something simpler like
> backend/commands/dbcommands.c createdb().

Note that in fact the bottom level heap_insert code will handle
assigning a new OID for you.  The only cases where calling code needs to
do that explicitly are when the OID has to be known before creation of
the new row for some reason (usually, circular OID references).
        regards, tom lane


pgsql-hackers by date:

Previous
From: Koichi Suzuki
Date:
Subject: Re: V4 of PITR performance improvement for 8.4
Next
From: Andrew Gierth
Date:
Subject: Re: hstore improvements?