gnumed-devel
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Gnumed-devel] Re: does v_basic_address still have triggers?


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





reply via email to

[Prev in Thread] Current Thread [Next in Thread]