Re: feature request for Postgresql Rule system. - Mailing list pgsql-general

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