Re: feature request for Postgresql Rule system.

> > Would there be any interest in making rules with multiple sql statements acid compliant?
> They are.

Am I missing something then, becuase I have cases where it is possible to get partial updates from
the multi-sql statement rule? I suppose that my understanding of "ACID" actually mean may not be
correct.

postgres=# select * from vwife;
id | name | dresssize
----+---------+-----------
3 | dodie | 13
4 | heather | 10
2 | katie | 11
(3 rows)

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

CREATE OR REPLACE RULE vwife_update AS ON UPDATE TO public.vwife
DO INSTEAD
(
UPDATE public.person
SET name = NEW.name
WHERE id = OLD.id;

UPDATE public.wife
SET dresssize = NEW.dresssize
WHERE id = OLD.id
);