On Mon, Aug 11, 2014 at 9:49 AM, Kevin Grittner <kgri...@ymail.com> wrote: > Rémi Cura <remi.c...@gmail.com> wrote: > >> 2014-08-11 5:33 GMT+02:00 John R Pierce <pie...@hogranch.com>: > >>> ah, you're releasing the lock before the insert is committed, >>> since this is all within a function call, its entirely within a >>> single transaction. > >> Oh no I hoped it was something fixable > > Well, it might be. Try using a transactional advisory lock and > letting it expire at the end of the transaction, rather than > explicitly releasing it before the transaction commits. Depending > on some other details, that might get it to do what you want.
Better to use vanilla LOCK TABLE statement in my opinion for this purpose. merlin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general