Are advisory locks guaranteed to be First Come First Serve? And can the behavior be relied upon? - Mailing list pgsql-general

From Hemil Ruparel
Subject Are advisory locks guaranteed to be First Come First Serve? And can the behavior be relied upon?
Date
Msg-id CANW1aT_Pc+xdoN_D-dK+j3uE+D_2wfFZu26aAfprWsoGhoNu-A@mail.gmail.com
Whole thread Raw
List pgsql-general
I was playing with Advisory locks. I opened three connections to the database And obtained a lock with the same key. I noticed that the locks were obtained in the order of requests. I was wondering whether the locks are guaranteed to be First Come First Serve and can this behaviour be relied upon.

I read the docs here. But it didn't mention anything.

Thanks a lot for your time and efforts

pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Calling a SQL function inside a C function
Next
From: Eric Zhu
Date:
Subject: Re: Calling a SQL function inside a C function