Postgres Pro
Downloads
Home   >   mailing lists

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

From Adrian Klaver
Subject Re: Strange behavior: row won't delete
Date
Msg-id 633008279.4323971236098192551.JavaMail.root@sz0030a.emeryville.ca.mail.comcast.net
Whole thread Raw
In response to Re: Strange behavior: row won't delete  (Phoenix Kiula <phoenix.kiula@gmail.com>)
Responses Re: Strange behavior: row won't delete  (Phoenix Kiula <phoenix.kiula@gmail.com>)
List pgsql-general
Tree view 
----- "Phoenix Kiula" <phoenix.kiula@gmail.com> wrote:

> > 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.
>
> --

Are you connected to the right database?. I have been in that situation, looking at the log for db A and doing things
indb B. 

Adrian Klaver
aklaver@comcast.net

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