On Mon, Aug 11, 2014 at 9:49 AM, Kevin Grittner <kgrittn@xxxxxxxxx> wrote: > Rémi Cura <remi.cura@xxxxxxxxx> wrote: > >> 2014-08-11 5:33 GMT+02:00 John R Pierce <pierce@xxxxxxxxxxxx>: > >>> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
