BUG advisory_lock

From: <Eugen(dot)Konkov(at)aldec(dot)com>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: BUG advisory_lock
Date: 2008-06-19 09:59:37
Message-ID: 005501c8d1f3$2fbe5500$1200a8c0@kharkov.localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

DECLARE
varUnlocked boolean;
BEGIN
varUnlocked:= pg_try_advisory_lock( 783264760123456 ); -- Try to lock function
IF not varUnlocked THEN return NULL; END IF; -- exit if locking is unsucessfull

WRONG QUERY HERE WHICH INTERRUPT EXECUTION

varUnlocked:= pg_advisory_unlock( 783264760123456 ); -- unlock function
END

NEXT time when I run this function I always get NULL until server reboot

EXPECTED: Pg must unlock if function execution failed

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Graham Leggett 2008-06-19 12:43:20 Re: BUG #4116: Cannot create tablespace: could not set permissions on directory
Previous Message Glenn 2008-06-18 16:22:29 BUG #4254: wont let me install it says account name already used or somthing