Re: psql reports back wrong number of affected rows.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Erwin Moller <erwinmoller(at)xs4all(dot)nl>
Cc: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: psql reports back wrong number of affected rows.
Date: 2011-06-14 15:05:49
Message-ID: 28607.1308063949@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Erwin Moller <erwinmoller(at)xs4all(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Crawford 2011-06-14 15:14:56 Re: Per-query local timezone
Previous Message Merlin Moncure 2011-06-14 15:00:54 Re: thoughts on interactive query