Re: poll: CHECK TRIGGER? - Mailing list pgsql-hackers

From Robert Haas
Subject Re: poll: CHECK TRIGGER?
Date
Msg-id CA+TgmoYKwsx-JgxYCmkLO9RaoEbc5pgyWbNrbz+Oi0fUJ4GHjA@mail.gmail.com
Whole thread Raw
In response to Re: poll: CHECK TRIGGER?  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: poll: CHECK TRIGGER?  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: poll: CHECK TRIGGER?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: poll: CHECK TRIGGER?  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
On Sat, Mar 3, 2012 at 9:23 PM, Alvaro Herrera
<alvherre@commandprompt.com> wrote:
> Uh!  Now that I read this I realize that what you're supposed to give to
> CHECK TRIGGER is the trigger name, not the function name!  In that
> light, using CHECK FUNCTION for this doesn't make a lot of sense.
>
> Okay, CHECK TRIGGER it is.

I confess to some bafflement about why we need dedicated syntax for
this, or even any kind of core support at all.  What would be wrong
with defining a function that takes regprocedure as an argument and
does whatever?  Sure, it's nicer syntax, but we've repeatedly rejected
patches that only provided nicer syntax on the grounds that syntax is
not free, and therefore syntax alone is not a reason to change the
core grammar.  What makes this case different?

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: review: CHECK FUNCTION statement
Next
From: Pavel Stehule
Date:
Subject: Re: poll: CHECK TRIGGER?