Michael Rowan <mike(dot)rowan(at)internode(dot)on(dot)net> wrote:
> PostgreSQL 220.127.116.11
> Can someone pls confirm that, provided I am doing it right, I can insert a row into a table where the primary key is serial NOT NULL and a (unique) value is provided in the offered data? I cannot see an answer to this specific point in the docs.
Sure, just try it. You only need to make sure that after
your insertion the corresponding sequence will not collide
with your data, e. g., you will have to setval() the se-
quence to MAX(value) (+ 1?).
In response to
pgsql-novice by date
|Next:||From: Josh Berkus||Date: 2010-07-21 20:47:01|
|Subject: Re: C Postgresql CGI|
|Previous:||From: Chris Browne||Date: 2010-07-21 16:44:36|
|Subject: Re: Inserting preset values into a serial column|