These are the commands I have run in the terminal
psql (17.0)
Type "help" for help.
postgres=# SELECT pg_advisory_lock_shared(1001); //initialising the shared
lock
pg_advisory_lock_shared
-
(1 row)
postgres=# SELECT pg_advisory_lock(1001); //exclusive lock
pg_advisory_
Thank you for the clarification. Now this explains the scenario.
Regards
Blessy Thomas
On Tue, 11 Feb 2025 at 15:56, Álvaro Herrera
wrote:
> On 2025-Feb-11, Blessy Thomas wrote:
>
> > These are the commands I have run in the terminal
> > psql (17.0)
> > Type "hel
