Unable to Delete a Row

From: "Kevin Crenshaw" <kcrenshaw(at)tiewireinc(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Unable to Delete a Row
Date: 2005-05-25 14:27:25
Message-ID: D8439C286CD66D4EBD89F853EBCE6E210F7B9D@ccs1.tiewireinc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message paul 2005-05-25 14:32:28 Re: Unable to Delete a Row
Previous Message Alan T. Miller 2005-05-25 06:33:03 Returning an array as a field in a larger query?