Re: working on support triggers on columns - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: working on support triggers on columns
Date
Msg-id 40E69482.1050707@familyhealth.com.au
Whole thread Raw
In response to Re: working on support triggers on columns  ("Greg Sabino Mullane" <greg@turnstep.com>)
List pgsql-hackers
> Glad to see this is being handled by someone. Other things
> of the top of my head:
>  
> Add support for psql to display the information.

For that he needs to update pg_get_triggerdef() in 
src/backend/utils/adt/ruleutils.c  He should probably also check pg_dump 
support for them.

> Add support
> for tab-completion if needed. *Update all relevant documentation.*
> Consider a mechanism for adding or dropping columns (e.g.
> ALTER TRIGGER). Handle dropped columns (via ALTER TABLE)
> gracefully. 

Not necessary ISTM - there's no way to alter existing triggers, and I 
don't see why we should bother with adding a command just for this.

Chris


pgsql-hackers by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: Adding column comment to information_schema.columns
Next
From: Bruno Wolff III
Date:
Subject: Re: Adding column comment to information_schema.columns