Re: poll: CHECK TRIGGER?
Pavel Stehule <pavel.stehule@gmail.com>
From: Pavel Stehule <pavel.stehule@gmail.com>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Alvaro Herrera <alvherre@commandprompt.com>, Tom Lane <tgl@sss.pgh.pa.us>, Pg Hackers <pgsql-hackers@postgresql.org>
Date: 2012-03-07T05:17:07Z
Lists: pgsql-hackers
Hello Robert, please, can you comment to this issue? And other, please. I am able to fix syntax to any form where we will have agreement. Regards Pavel 2012/3/6 Pavel Stehule <pavel.stehule@gmail.com>: > Hello > >> >> When I try to look on some multicheck form: >> >> a) CHECK FUNCTION ALL ON table_name >> b) CHECK TRIGGER ALL ON table_name >> >> then more natural form is @b (for me). Personally, I can live with >> one, both or second form, although I prefer CHECK TRIGGER. >> > > I though some time more. > > if somebody would to check all custom function, then he can write > > CHECK FUNCTION ALL > > what about triggers? > > CHECK TRIGGER ALL > > but if we don't implement CHECK TRIGGER, then this statement will look like > > CHECK FUNCTION ALL ON ALL ??? > > and this is unclean - probably it doesn't mean - check trigger > function with any table. So this is other argument for CREATE TRIGGER. > > Nice a day > > Pavel > > >> notes? >> >> Regards >> >> Pavel >> >> >>> -- >>> Robert Haas >>> EnterpriseDB: http://www.enterprisedb.com >>> The Enterprise PostgreSQL Company >>> >>> -- >>> Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) >>> To make changes to your subscription: >>> http://www.postgresql.org/mailpref/pgsql-hackers