Is there some way for Postgres to recover from "frozen" locks?
Ex:
PHP opens a persistent connection to the database.
Script queries and recieves a lock.
Something happens so that the lock is not released.
Other scripts are forced to wait for locks.
How can I make it so that the corrupted script does not prevent
other scripts from receiving locks?
Is there some way to release the "bad" lock?
Thanks.
gh