Re: Strange behavior: row won't delete

From: Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Strange behavior: row won't delete
Date: 2009-03-03 16:18:26
Message-ID: e373d31e0903030818s27239998sb1b369d62cb9571e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Mar 4, 2009 at 12:10 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com> writes:
>> Now when I do:
>>   vacuum analyze TABLENAME
>> or
>>   delete from TABLENAME where id = 99
>> Nothing happens! The carriage return means the my shell cursor goes to
>> the next line, but it just stays there.
>
> Did you forget the semicolon?

Cute. But no :)

myuser=# delete from visitcount where id = 99;

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Phoenix Kiula 2009-03-03 16:27:25 Re: Strange behavior: row won't delete
Previous Message Alan Hodgson 2009-03-03 16:17:54 Re: Strange behavior: row won't delete