On Tue, Jan 17, 2006 at 01:28:03PM -0500, Jaime Casanova wrote: > is the same problem as with temp tables, you must put their creation, > and in this case even the nextval in an execute...
Curious that it works in 8.0, though. I wonder if the failure in 8.1 is an artifact of changing sequence functions like nextval() to take a regclass argument (the sequence OID) instead of a text argument (the sequence name); that would affect what gets put in the function's cached plan. -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org