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