Re: Call for Google Summer of Code (GSoC) 2012: Project ideas?
От | Thomas Kellerer |
---|---|
Тема | Re: Call for Google Summer of Code (GSoC) 2012: Project ideas? |
Дата | |
Msg-id | jjq9ml$4k3$1@dough.gmane.org обсуждение исходный текст |
Ответ на | Call for Google Summer of Code (GSoC) 2012: Project ideas? (Stefan Keller <sfkeller@gmail.com>) |
Ответы |
Re: Call for Google Summer of Code (GSoC) 2012: Project ideas?
|
Список | pgsql-general |
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 singlestatement? 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 functionsbut would still allow the flexibility to re-use trigger functions in more than one trigger. Regards Thomas
В списке pgsql-general по дате отправления: