> There's no "select * from table where pkey=x for insert;" which would block > on uncommitted inserts/updates of pkey=x and other selects for insert/update.
How about user locks? Isn't there something in contrib/ for that??? I could do a userlock on the primary key, whether it existed or not?
Depends on your case, whether you can correctly convert your potential primary keys into integers to be locked on.
It still requires full cooperation by all relevant apps/clients.
Actually select ... for updates also require cooperation, but it's a standard way of doing things, so apps that don't cooperate can be said to be broken :).
Is there a standard for "select ... for insert"? Or lock table for insert where pkey=x?
Regards, Link.
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
