Postgres Pro
Downloads
Home   >   mailing lists

Re: Strange behavior: row won't delete - Mailing list pgsql-general

From Phoenix Kiula
Subject Re: Strange behavior: row won't delete
Date
Msg-id e373d31e0903030827h4666f470u9e32e563d6076e2e@mail.gmail.com
Whole thread Raw
In response to Re: Strange behavior: row won't delete  (Alan Hodgson <ahodgson@simkin.ca>)
Responses Re: Strange behavior: row won't delete  (Phoenix Kiula <phoenix.kiula@gmail.com>)
Re: Strange behavior: row won't delete  (Adrian Klaver <aklaver@comcast.net>)
List pgsql-general
Tree view 
> commit the transaction where you altered the table. It has an open lock on
> the table.



=# commit;

WARNING:  there is no transaction in progress
COMMIT
Time: 0.282 ms


So no, there's nothing pending.

pgsql-general by date:

Previous
From: Phoenix Kiula
Date:
Subject: Re: Strange behavior: row won't delete
Next
From: Phoenix Kiula
Date:
Subject: Re: Strange behavior: row won't delete