Re: Unable to Delete a Row - Mailing list pgsql-novice

From paul@entropia.co.uk
Subject Re: Unable to Delete a Row
Date
Msg-id 42949A8C.8601.7117B1C@localhost
Whole thread Raw
In response to Unable to Delete a Row  ("Kevin Crenshaw" <kcrenshaw@tiewireinc.com>)
List pgsql-novice
Try:
DELETE FROM CONTACTS WHERE CONTACTID = '853';

>
> I am running Postgres v8.0.1 on Win XP Pro. When I try to delete a record, which I know exists,
> I simply get ˜DELETE 0™ as a response. Please Help!
>
> Here is a little more info:
>
> DELETE FROM CONTACTS WHERE CONTACTID = 853;
>
> Query returned successfully: 0 rows affected, 62 ms execution time.
> -- Executing query:
> Select * from contacts where contactid = 853;
>
>
> Total query runtime: 15 ms.
> Data retrieval runtime: 16 ms.
> 1 rows retrieved.
>
> -- Executing query:
> EXPLAIN ANALYSE Delete from contacts where contactid = 853;
>
>
> Total query runtime: 63 ms.
> Data retrieval runtime: 0 ms.
> 3 rows retrieved.
>
> Thanks in advance
>
> kevin crenshaw
>
>

pgsql-novice by date:

Previous
From: "Kevin Crenshaw"
Date:
Subject: Unable to Delete a Row
Next
From: "Glauter Moulin Coelho"
Date:
Subject: Migration from MySQL