Unable to delete rows...

From: KroK <krok(at)void(dot)ru>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Unable to delete rows...
Date: 2003-03-28 10:22:30
Message-ID: 20030328102230.GA99458@frost.void.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hello.

I'm Using PostgreSQL v. 7.3.2 on FreeBSD 4.7-RELEASE-p7.

I was unable to delete several rows :

void=> select * from banners where banner is NULL;
id | count | max | banner_group | banner
----+-------+-------+--------------+--------
25 | 2328 | 10008 | 2 |
4 | 477 | 3336 | 33554438 |
(2 rows)

void=> delete from banners where banner is NULL;
DELETE 0
void=> select * from banners where banner is NULL;
id | count | max | banner_group | banner
----+-------+-------+--------------+--------
25 | 2328 | 10008 | 2 |
4 | 477 | 3336 | 33554438 |
(2 rows)

void=>

Is it bug or there are some errors in my queries ?

Thanks.

Krok.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message A.Bhuvaneswaran 2003-03-28 13:48:57 Re: Unable to delete rows...
Previous Message Rod Taylor 2003-03-28 04:10:57 Re: Bug #918: pg_dump problem w/ SEQUENCE