On Mon, Aug 11, 2014 at 9:49 AM, Kevin Grittner <[email protected]> wrote: > Rémi Cura <[email protected]> wrote: > >> 2014-08-11 5:33 GMT+02:00 John R Pierce <[email protected]>: > >>> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
