Richard Broersma Jr wrote:
> postgres=# update vwife
> set name = 'Katheryn',
> dresssize = 12
> where (id,name,dresssize)=(2,'katie',11);
> UPDATE 0
>
> postgres=# select * from vwife;
> id | name | dresssize
> ----+----------+-----------
> 3 | dodie | 13
> 4 | heather | 10
> 2 | Katheryn | 11
> ^^^^^^^^ <-- update 0 is false
None of A, C, I, or D say that you need to report a truthful update
count.
The fact that the update count is wrong with updatable views is a known
deficiency.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/