| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Cc: | Richard Broersma Jr <rabroersma(at)yahoo(dot)com>, Jeff Davis <pgsql(at)j-davis(dot)com> |
| Subject: | Re: feature request for Postgresql Rule system. |
| Date: | 2006-12-18 22:04:20 |
| Message-ID: | 200612182304.20752.peter_e@gmx.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Davis | 2006-12-18 22:05:41 | Re: feature request for Postgresql Rule system. |
| Previous Message | Alvaro Herrera | 2006-12-18 21:52:53 | Re: Second attempt, roll your own autovacuum |