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