Re: nextval/dbi question

harrold@sage.che.pitt.edu writes:
> i want to insert data into a table that has a serialized key. then i want
> the value of the key for the row i just inserted. from the stuff i read
> on the net i though i was supposed to run the nextval command first then
> preform the insert.

That is about the simplest and most obvious way to do it, IMHO.  What
you're missing is that you have to explicitly insert the value you got
from nextval() into the key column.  If you allow the key column to be
defaulted in the INSERT, then nextval() gets run again.

            regards, tom lane