Re: Noob question: how to auto-increment index field on INSERT?

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Noob question: how to auto-increment index field on INSERT?
Date: 2009-11-19 19:14:27
Message-ID: he45eh$549$1@ger.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Ken MacDonald wrote on 19.11.2009 19:59:
> Thanks to all who replied so far. I agree that using the serial type
> would be ideal, and in fact set up a couple test DB's that way.
> Unfortunately, Django is auto-generating this field from its data
> models, and I don't seem to have much/any control over its type.
>
> Looking at pgadmin some more, it appears that column 'id' is set up with
> a default value of 'nextval('tablename_id_seq'::regclass)'.

Which is essentially what "serial" is: just a shorthand for the above construct

Thomas

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Jasen Betts 2009-11-20 09:46:04 Re: My second PL/pgSQL function - minor problem
Previous Message Ken MacDonald 2009-11-19 18:59:00 Re: Noob question: how to auto-increment index field on INSERT?