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@xxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
