Re: feature request for Postgresql Rule system.

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: feature request for Postgresql Rule system.
Date: 2006-12-19 05:55:43
Message-ID: 88733.7003.qm@web31806.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> > postgres=# update vwife
> > set name = 'Katheryn',
> > dresssize = 12
> > where (id,name,dresssize)=(2,'katie',11);
> > UPDATE 0
> > postgres=# select * from vwife;
> > id | name | dresssize
> > ----+----------+-----------
> > 2 | Katheryn | 11 <- DRESSSIZE should not be 12 correct?
> > ^^^^^^^^ <-- update did change name but not dresssize?
> 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 sorry for belaboring this point, but I just wanted to verify if what I am seeing is already
know (whether it is a deficiency or not). My concern regarding the rule system is not related to
the incorrect update count but the fact that my update statement was suppose to change BOTH name
AND dresssize. However, as you see only the name was changed, dresssize remains unchanged.
Therefore, I assumed that the update statement was not completed "atomically".

Regards,
Richard Broersma Jr.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message A. Kretschmer 2006-12-19 06:06:51 Re: View optimization
Previous Message Chris 2006-12-19 05:08:23 Re: Changes in 8.2's PHP behaviour?