Re: Delete Problem

Michael Fuhr wrote:
> [Please copy the mailing list on replies so others can participate
> in and learn from the discussion.]
>
> On Thu, Jul 13, 2006 at 03:32:43PM +1000, Jamie Deppeler wrote:
>
>> Michael Fuhr wrote:
>>
>>> On Thu, Jul 13, 2006 at 01:45:36PM +1000, Jamie Deppeler wrote:
>>>
>>>> Just today i have noticed i have one certain table  that i cannot delete
>>>> any records from
>>>>
>>> What happens when you try to delete?  Do you get an error?  Does
>>> the delete succeed but report zero rows deleted?  Something else?
>>> What does "EXPLAIN ANALYZE DELETE ..." show?  Is the delete done
>>> in a transaction that doesn't commit?
>>>
>> Delete is performed without any errors or warnings but when i refresh
>> the found set it is still in the table
>>
>
> What do you mean by "refresh the found set"?  What client interface
> are you using?  Might the deleting transaction not be committing?
> What happens if you do the delete using psql?  What version of
> PostgreSQL are you running?
>
>

 From psql

db=# select "primary" from job where "primary" = 370;
 primary
---------
     370
(1 row)

db=# delete from job where "primary" = 370;
DELETE 0


DB is Postgresql 8.0

OS is Debian