|
From: | catmat |
Subject: | [Gnumed-devel] Re: does v_basic_address still have triggers? |
Date: | Sat, 29 Jan 2005 18:31:49 +1100 |
User-agent: | Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.5) Gecko/20041231 |
catmat wrote:
A while ago, v_basic_address was updateable because of triggers, but they seem to be missing on the salaam.homeunix.com database. Are they supposed to be still there?
the following rows in pg_rules seem to be missing on salaam gnumed.public | v_basic_address | update_address | CREATE RULE update_address AS ON UPDATE TO v_basic_address DO INSTEAD UPDATE address SET number = new.number, addendum = new.street2, id_street = find_street(new.street, (SELECT urb.id FROM urb, state WHERE (((((urb.name = new.city) AND (urb.postcode = new.postcode)) AND (urb.id_state = state.id)) AND (state.code = new.state)) AND (state.country = new.country)))) WHERE (address.id = old.addr_id); public | v_basic_address | delete_address | CREATE RULE delete_address AS ON DELETE TO v_basic_address DO INSTEAD DELETE FROM address WHERE (address.id = old.addr_id); public | v_basic_address | insert_address | CREATE RULE insert_address AS ON INSERT TO v_basic_address DO INSTEAD INSERT INTO address (id_street, number, addendum) VALUES (find_street(new.street, find_urb((new.country)::text, (new.state)::text, new.postcode, new.city)), new.number, new.street2);
[Prev in Thread] | Current Thread | [Next in Thread] |