Re: nextval/dbi question

hey.

that's just dandy-it works fine. thanks everyone for helping me sort out
my misunderstanings.

--
john
There is no operating system but linux and linus is its kernel maintainer.

Sometime in August Tom Lane assaulted keyboard and produced...

|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
|