Search Postgresql Archives

Re: psql reports back wrong number of affected rows.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux