Skip site navigation (1) Skip section navigation (2)

Re: Triggers with DO functionality

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: "David E(dot) Wheeler" <david(at)justatheory(dot)com>
Cc: Thom Brown <thom(at)linux(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Triggers with DO functionality
Date: 2012-02-17 16:43:53
Message-ID: 4F3E83C9.1050905@dunslane.net (view raw or flat)
Thread:
Lists: 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

In response to

Responses

pgsql-hackers by date

Next:From: Thom BrownDate: 2012-02-17 16:44:11
Subject: Re: Triggers with DO functionality
Previous:From: Marti RaudseppDate: 2012-02-17 16:31:22
Subject: Re: Copyright notice for contrib/cube?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group