Re: Unable to delete rows...

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

You must have triggers or rules on DELETE event which conflict the action.

regards,
bhuvaneswaran