Re: Triggers on columns - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Triggers on columns
Date
Msg-id 20090903025408.GB5896@alvh.no-ip.org
Whole thread Raw
In response to Re: Triggers on columns  (Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
List pgsql-hackers
Itagaki Takahiro wrote:
> 
> David Fetter <david@fetter.org> wrote:
> 
> > > It's still arguable that we should add dependencies from column
> > > triggers to referenced columns.
> > 
> > +1 for adding the dependencies.
> 
> But how? First, I tried to use existing dependency mechanism:
> 
>     ObjectAddress referenced;
>     referenced.classId = AttributeRelationId;
>     referenced.objectId = {relid};
>     referenced.objectSubId = {attnum};
>     recordDependencyOn(&myself, &referenced, DEPENDENCY_NORMAL);
> 
> but we don't use ObjectAddress with classId = AttributeRelationId
> for now in any places. Does it work?

Well, apparently you've been tasked with making sure it works properly :-)
The only problem I see with it is the fact that the objectId is not the
attribute's OID, but it should be possible.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.


pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: community decision-making & 8.5
Next
From: Joshua Tolley
Date:
Subject: Re: Implementation of GROUPING SETS (T431: Extended grouping capabilities)