Hi all, 2012/3/14 Thomas Kellerer <spam_eater@xxxxxxx>: > Stefan Keller, 08.03.2012 20:40: > >> Hi >> >> I do have a student who is interested in participating at the Google >> Summer of Code (GSoC) 2012 >> Now I have the "burden" to look for a cool project... Any ideas? >> >> -Stefan >> > > What about an extension to the CREATE TRIGGER syntax that combines trigger > definition and function definition in a single statement? > > Something like: > > CREATE TRIGGER my_trg BEFORE UPDATE ON some_table > FOR EACH ROW EXECUTE > DO > $body$ > BEGIN > ... here goes the function code ... > END; > $body$ > LANGUAGE plpgsql; > > which would create both objects (trigger and trigger function) at the same > time in the background. > > The CASCADE option of DROP TRIGGER could be enhanced to include the > corresponding function in the DROP as well. > > This would make the syntax a bit easier to handle for those cases where a > 1:1 relationship exists between triggers and functions but would still allow > the flexibility to re-use trigger functions in more than one trigger. > > Regards > Thomas Thanks to all who responded here. There are now two students here at our university and it seems that they prefer another open source project (which I support too). Let's take some these good ideas to the Postgres wiki (if there is an idea page there :->) -Stefan -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
