Re: psql reports back wrong number of affected rows. - Mailing list 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