Re: Strange behavior: row won't delete

From: Adrian Klaver <aklaver(at)comcast(dot)net>
To: Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, Alan Hodgson <ahodgson(at)simkin(dot)ca>
Subject: Re: Strange behavior: row won't delete
Date: 2009-03-03 16:36:32
Message-ID: 633008279.4323971236098192551.JavaMail.root@sz0030a.emeryville.ca.mail.comcast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


----- "Phoenix Kiula" <phoenix(dot)kiula(at)gmail(dot)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 in db B.

Adrian Klaver
aklaver(at)comcast(dot)net

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Phoenix Kiula 2009-03-03 16:39:44 Re: Strange behavior: row won't delete
Previous Message Phoenix Kiula 2009-03-03 16:33:08 Re: Strange behavior: row won't delete