Re: incomplete transaction keeps table locked?

Ok, thanks.

Hopefully upgrading PHP will get auto-rollbacks performed on exit of any
script where i've started a transaction and forgotten to do an explicit
rollback or commit.

george

Tom Lane wrote:
>
> 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