Re: incomplete transaction keeps table locked?

gherson@snet.net (George Herson) writes:
> Are there any circumstances when exiting a PHP web script
> where you've started a transaction (with Begin Work) but haven't explicitly 
> done a Commit Work or Rollback before it ends will lock you out of
> a table (until you restart postgresql)?

The symptoms you describe sound like multiple transactions trying to
update the same row.  There is a row-level lock that prevents the later
ones from completing until the first one commits or aborts.

			regards, tom lane