From: | "Dann Corbit" <DCorbit(at)connx(dot)com> |
---|---|
To: | "Maurice Yarrow" <yarrow(at)best(dot)com>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: CREATE TABLE initial value for PRIMARY KEY |
Date: | 2006-10-27 19:10:03 |
Message-ID: | D425483C2C5C9F49B5B7A41F8944154757DCF7@postal.corporate.connx.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Use a sequence and set the initial value of the sequence.
> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-
> owner(at)postgresql(dot)org] On Behalf Of Maurice Yarrow
> Sent: Friday, October 27, 2006 11:51 AM
> To: pgsql-general(at)postgresql(dot)org
> Subject: [GENERAL] CREATE TABLE initial value for PRIMARY KEY
>
> Hello Postgres community
>
> Is there a formal way to set an initial value for a PRIMARY KEY
> when CREATE TABLE ? (This would be some large number,
> typically.)
>
> Or is it only possible to do this by first creating the table, and
> then inserting a bogus record forcing the initial value by
> specification (and then, presumably, deleting this bogus
> record) ?
>
> Maurice Yarrow
>
>
>
> ---------------------------(end of
broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-10-27 19:12:14 | Re: CREATE TABLE initial value for PRIMARY KEY |
Previous Message | Alvaro Herrera | 2006-10-27 18:54:41 | Re: Mailing list problem? |