Delete statement does not work with PostgreSQL 8.0.1

Поиск
Список
Период
Сортировка
От Ledina Hido
Тема Delete statement does not work with PostgreSQL 8.0.1
Дата
Msg-id 0A06BA4A-CB42-4557-8137-8B65499D2A10@ecs.soton.ac.uk
обсуждение исходный текст
Ответы Re: Delete statement does not work with PostgreSQL 8.0.1  (Richard Huxton <dev@archonet.com>)
Список pgsql-general
Hi,

I have just today installed the new version of PostgreSQL (8.1.0),
and my old code seems to have stopped working.

I am basically trying to delete a row from a table:

DELETE FROM "CON" WHERE "ref"='CON5';

I have checked and CON5 is definitively in the CON table. I tried
using JDBC, pgAdminIII and command line but it doesn't seem to work.
I get a message saying 0 rows have been affected, as if the item was
not in the table. Am I doing something wrong? Has the syntax changed
or is this just a bug?

Thanks for your help,
Ledina

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

Предыдущее
От: Brent Wood
Дата:
Сообщение: Re: Best way to represent values.
Следующее
От: Dennis Veatch
Дата:
Сообщение: Re: Best way to represent values.