Re: Triggers on columns - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Triggers on columns
Date
Msg-id 1254335450.24827.6.camel@vanquo.pezone.net
Whole thread Raw
In response to Re: Triggers on columns  (Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
Responses Re: Triggers on columns
List pgsql-hackers
On Mon, 2009-09-14 at 18:58 +0900, Itagaki Takahiro wrote:
> Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp> wrote:
> 
> > Ok, the attached patch implements standard-compliant version of
> > column trigger.
> 
> Here is an updated version of column-level trigger patch.
> I forgot to adjust pg_get_triggerdef() in the previous version.
> pg_dump also uses pg_get_triggerdef() instead of building
> CREATE TRIGGER statements to avoid duplicated codes if the
> server version is 8.5 or later.

What is the purpose of the new pg_get_triggerdef() variant?  OK, the
parameter name "pretty_bool" gives a hint, but what does this have to do
with column triggers?  Maybe you could try to explain this in more
detail.  Ideally split the patch into two: one that deals with
pg_get_triggerdef(), and one that deals with column triggers.

If you want a "pretty" option on pg_get_triggerdef(), you could nowadays
also implement that via a parameter default value instead of a second
function.



pgsql-hackers by date:

Previous
From: Roger Leigh
Date:
Subject: Re: Unicode UTF-8 table formatting for psql text output
Next
From: Peter Eisentraut
Date:
Subject: Re: Unicode UTF-8 table formatting for psql text output