604
604
("(,t)","(1,f)",)
607
-- check that using a function as a trigger over two tables works correctly
608
CREATE FUNCTION trig1234() RETURNS trigger LANGUAGE plpythonu AS $$
609
TD["new"]["data"] = '1234'
612
CREATE TABLE a(data text);
613
CREATE TABLE b(data int); -- different type conversion
614
CREATE TRIGGER a_t BEFORE INSERT ON a FOR EACH ROW EXECUTE PROCEDURE trig1234();
615
CREATE TRIGGER b_t BEFORE INSERT ON b FOR EACH ROW EXECUTE PROCEDURE trig1234();
616
INSERT INTO a DEFAULT VALUES;
624
INSERT INTO b DEFAULT VALUES;