Re: Automatic increment

Julio Cuz, Jr. (jcuz@rccd.cc.ca.us) wrote:
> Some of you guys suggested to use the 'SERIAL' type for a field that needs
> to be AUTOMATICALLY INCREASED BY 1 by PGSQL without user intervention, but
> it doesn't seem to work.  What am I doing wrong?

Though I wasn't here for that, here's how I normally declare
automatically-incrementing values:

CREATE SEQUENCE foo_id;

CREATE TABLE foo (
    foo_id integer not null primary key default nextval(foo_id);

    ...
);

insertions to foo get their own unique ID.  With the php extension, you
can get the oid of the row that was inserted and go get the ID if you
happen to need it.