Re: feature request for Postgresql Rule system.

[Richard Broersma Jr <rabroersma@xxxxxxxxx>]

> > 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
);