Thread: check if the same function is already running, then exit!
Before running a running a function, i would check only 1 instance is running. If alreaady a function is running, the existing function should exist with the msg that already a function with same is running.
If somebody has already used such a faeture, can u please share or
Can you tell me the table and column from which I could this info.
Thanks,
Hi
you can use a advisory locks for singleton implementation http://www.postgresql.org/docs/9.4/static/functions-admin.html#FUNCTIONS-ADVISORY-LOCKS
2015-01-26 20:58 GMT+01:00 Suresh Raja <suresh.rajaabc@gmail.com>:
Before running a running a function, i would check only 1 instance is running. If alreaady a function is running, the existing function should exist with the msg that already a function with same is running.If somebody has already used such a faeture, can u please share orCan you tell me the table and column from which I could this info.Thanks,
On 1/26/2015 1:58 PM, Suresh Raja wrote: > Before running a running a function, i would check only 1 instance is > running. If alreaady a function is running, the existing function > should exist with the msg that already a function with same is running. > > If somebody has already used such a faeture, can u please share or > Can you tell me the table and column from which I could this info. > > Thanks, Advisory locks might work for you: http://www.postgresql.org/docs/9.4/static/explicit-locking.html (at the bottom of the page) google will find other's talking about it: "postgres advisory lock" -Andy