Re: Is there an equivalent to sp_getapplock, sp_releaseapplock in PostgreSql?

Hi Ityas

Advisory locks do not act like the locks in MSSQL,  Postgresql will ignore advisory locks for other transactions,  its up the applications layer to poll/ obey/ enforce advisory locks

You can do the type of locking as  in MSSQL with Postgresql but its avoided in practice as that is the point of MVCC,  allow the database to handle locking/updating of resources.  Odds of Deadlocks go way down...

Postgresql has always run in the optional MSSQL Snap Shot Isolation Mode https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/sql/snapshot-isolation-in-sql-server

I think MSSQL is now the only major database still shipped with MVCC turned off..