Home > mailing lists

Re: Is there an equivalent to sp_getapplock, sp_releaseapplock inPostgreSql? - Mailing list pgsql-general

From	Andrei Zhidenkov
Subject	Re: Is there an equivalent to sp_getapplock, sp_releaseapplock inPostgreSql?
Date	December 13, 2019 17:05:38
Msg-id	A9FB6168-C164-46C4-903C-A0CFF8ADC77A@n26.com Whole thread Raw
In response to	Is there an equivalent to sp_getapplock, sp_releaseapplock in PostgreSql? (İlyas Derse <ilyasderse@gmail.com>)
Responses	Re: Is there an equivalent to sp_getapplock, sp_releaseapplock in PostgreSql?
List	pgsql-general

I’m not sure what these function exactly do in MSSQL but what in Postgres you probably can use “Advisory Locks” (https://www.postgresql.org/docs/9.4/explicit-locking.html) in order to achive this.

On 13. Dec 2019, at 13:31, İlyas Derse <ilyasderse@gmail.com> wrote:

sp_getapplock

From: İlyas Derse
Date: 13 December 2019, 15:31:50
Subject: Is there an equivalent to sp_getapplock, sp_releaseapplock in PostgreSql?

From: Justin
Date: 13 December 2019, 17:41:46
Subject: Re: Is there an equivalent to sp_getapplock, sp_releaseapplock in PostgreSql?