gherson(at)snet(dot)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