Re: psql reports back wrong number of affected rows.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: psql reports back wrong number of affected rows.
Дата
Msg-id 28607.1308063949@sss.pgh.pa.us
обсуждение исходный текст
Ответ на psql reports back wrong number of affected rows.  (Erwin Moller <erwinmoller@xs4all.nl>)
Ответы Re: psql reports back wrong number of affected rows.  ("erwin@darwine.nl" <erwin@darwine.nl>)
Список pgsql-general
Erwin Moller <erwinmoller@xs4all.nl> writes:
> Then:
> delete from tblissue where issueid=1;
> DELETE 1

> Postgresql now deletes all rows that had a 1 for parentissueid. (5 in my
> testcase).
> That was correct, and as I intended, but why does Postgres answer
> "DELETE 1" instead of DELETE 6?

It's reporting the number of rows deleted from tblissue.  Cascade
effects are not relevant.

            regards, tom lane

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

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: thoughts on interactive query
Следующее
От: Steve Crawford
Дата:
Сообщение: Re: Per-query local timezone