Erwin Moller <erwinmoller@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general