Re: [GENERAL] Locking several tables within one transaction

2011-07-23 Thread Ilia Lilov
e within single transaction) SELECT pg_advisory_unlock_shared(2); --Disconnect database If anyone needs further explanation, fell free to mail me. Ilia Lilov. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Locking several tables within one transaction

2011-07-22 Thread Ilia Lilov
lock all the tables manually, so using single pg_advisory_lock() would be better solution, but if I understand correctly, advisory lock works within single session, but two places from which my database can be accessed will use different session. Am I right? Is there more laconic solution for my goal