Advisory locks

From: "Tom Paynter" <tompaynter(at)tdpe(dot)co(dot)uk>
To: pgsql-sql(at)postgresql(dot)org
Subject: Advisory locks
Date: 2015-02-11 10:32:13
Message-ID: da68e78ba167e84fc7e58c74ac5ae64d.squirrel@webmail.tdpe.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello All,

I have a quick question about advisory locks, that I have not been able to
figure out from the documentation.

Say I have two tables:
CREATE TABLE table_a
(
table_a_id serial primary key,
some more rows....
);

CREATE TABLE table_b
(
table_b_id serial primary key,
some more rows....
);

And I execute the following lines (from separate sessions):
SELECT pg_advisory_lock(table_a_id) FROM table_a WHERE table_a_id=5;
SELECT pg_advisory_lock(table_b_id) FROM table_b WHERE table_b_id=5;

Will this try to acquire the same lock?
Or is the id tied to the table somehow?

Thanks for your time.
Tom

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message daku.sandor 2015-02-11 10:40:38 Re: Advisory locks
Previous Message Glyn Astill 2015-02-10 13:05:50 Re: Implementing incremental client updates