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. -- Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general