[EMAIL PROTECTED] wrote: > 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
You can unlock it in an EXCEPTION block to be safe. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
