Re: [BUGS] BUG #1083: Insert query reordering interacts badly with NEXTVAL()/CURRVAL()

[Tom Lane]

"Martin Langhoff (Catalyst IT)" <[EMAIL PROTECTED]> writes:
> Thanks for the clarification. I am curious, however: I can't find a 
> means to achieve the same effect in a deterministic manner. Any pointers?

How about

SELECT nextval('seq');       -- ignore result

INSERT INTO ... VALUES (currval('seq'), currval('seq'));

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend