Re: primary key

On 14/03/2011 07:57, Peter Evens wrote:
>
> hello,
>
> i have a question about the PRIMARY KEY,
> how can we let it start from for example 1000 instead of 1?
>
> This is our program:
> CREATE TABLE hy3_pack
> (
>   hy3_id serial NOT NULL,
>   hy3_serie_nummer text NOT NULL,
>   hy3_barcode text NOT NULL,
>   hy3_type_vulling text NOT NULL,
>   hy3_tarra_gewicht text,
>   hy3_artikel_id numeric NOT NULL,
>   hy3_refill boolean,
>   vernietigd boolean,
>   opmerking text,
>   CONSTRAINT hy3_pack_pkey PRIMARY KEY (hy3_id)
> )
> WITH (
>   OIDS=FALSE
> );
> ALTER TABLE hy3_pack OWNER TO postgres;
>
> what must i change in my program?

After the CREATE TABLE, use setval() to set the current value of the
sequence used for hy3_id.

http://www.postgresql.org/docs/9.0/static/functions-sequence.html

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie