Re: Triggers with DO functionality - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: Triggers with DO functionality
Date
Msg-id 4F3E83C9.1050905@dunslane.net
Whole thread Raw
In response to Re: Triggers with DO functionality  ("David E. Wheeler" <david@justatheory.com>)
Responses Re: Triggers with DO functionality  (Thom Brown <thom@linux.com>)
Re: Triggers with DO functionality  (Gianni Ciolli <gianni.ciolli@2ndquadrant.it>)
List pgsql-hackers

On 02/17/2012 11:29 AM, David E. Wheeler wrote:
> On Feb 17, 2012, at 5:22 AM, Thom Brown wrote:
>
>> The purpose being to only have a single statement to set up the
>> trigger rather than setting up a separate trigger function which will
>> unlikely be re-used by other triggers... or is this of dubious
>> benefit?
> +1, though I imagine it would just give it a generated name and save it anyway, eh?
>



Before we rush into this, let's consider all the wrinkles. For example, 
what if you need to change the function? And how would you edit the 
function in psql? It might be a bit more involved that it seems at first 
glance, although my initial reaction was the same as David's.

cheers

andrew


pgsql-hackers by date:

Previous
From: Marti Raudsepp
Date:
Subject: Re: Copyright notice for contrib/cube?
Next
From: Thom Brown
Date:
Subject: Re: Triggers with DO functionality