>>>>> "J" == Jeremy Henty <jeremy / chaos.org.uk> writes: J> create trigger test_update_trigger J> after insert or update or delete J> on test FOR EACH ROW J> execute procedure J> test_update(); svg% psql plruby_test Welcome to psql 8.0.1, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help with psql commands \g or terminate with semicolon to execute query \q to quit plruby_test=# create function test_update() plruby_test-# returns trigger as ' plruby_test'# PL::OK plruby_test'# ' language 'plruby'; CREATE FUNCTION plruby_test=# create table test ( foo text ); CREATE TABLE plruby_test=# create trigger test_update_trigger plruby_test-# after insert or update or delete plruby_test-# on test plruby_test-# FOR EACH ROW plruby_test-# execute procedure plruby_test-# test_update(); CREATE TRIGGER plruby_test=# insert into test ( foo ) plruby_test-# values (''); INSERT 34166 1 plruby_test=# \q svg% I'll add the test for the next version Guy Decoux