Re: Unable to Delete a Row

Поиск

Список

Период

Сортировка

От	paul@entropia.co.uk
Тема	Re: Unable to Delete a Row
Дата	25 мая 2005 г. 11:35:26
Msg-id	42949A8C.8601.7117B1C@localhost обсуждение
Ответ на	Unable to Delete a Row ("Kevin Crenshaw" <kcrenshaw@tiewireinc.com>)
Список	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 по дате отправления: