From: | Richard Broersma Jr <rabroersma(at)yahoo(dot)com> |
---|---|
To: | Jeff Davis <pgsql(at)j-davis(dot)com> |
Cc: | General PostgreSQL List <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: feature request for Postgresql Rule system. |
Date: | 2006-12-18 21:42:29 |
Message-ID: | 686494.20594.qm@web31807.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
);
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2006-12-18 21:52:53 | Re: Second attempt, roll your own autovacuum |
Previous Message | Glen Parker | 2006-12-18 21:31:03 | Second attempt, roll your own autovacuum |