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/ ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
