Unable to Delete a Row

Поиск
Список
Период
Сортировка
От Kevin Crenshaw
Тема Unable to Delete a Row
Дата
Msg-id D8439C286CD66D4EBD89F853EBCE6E210F7B9D@ccs1.tiewireinc.com
обсуждение исходный текст
Ответы Re: Unable to Delete a Row  (paul@entropia.co.uk)
Список 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

 

В списке pgsql-novice по дате отправления:

Предыдущее
От: "Alan T. Miller"
Дата:
Сообщение: Returning an array as a field in a larger query?
Следующее
От: paul@entropia.co.uk
Дата:
Сообщение: Re: Unable to Delete a Row