Re: [BUGS] my pl/pgsql functions return weird results

2002-02-22 Thread Tom Lane
Olivier Garcia <[EMAIL PROTECTED]> writes: > [ can't re-implement nextval() in plpgsql ] The problem is that plpgsql doesn't do SetQuerySnapshot between statements of a function, so although your different invocations are forced to wait for each other by the LOCK statements, they cannot see each

[BUGS] my pl/pgsql functions return weird results

2002-02-22 Thread Olivier Garcia
Hi! My base contains a table objectid create table objectid( next bigint ); INSERT INTO objectid values(1); I do really need to use this table like if it was a sequence so I made some pl/pgsql functions ( functions at the end of the mail ). But when I run them in three psql at the same