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

Re: Fwd: Start up question about triggers

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: Aaron Bono <postgresql(at)aranya(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Fwd: Start up question about triggers
Date: 2006-06-23 05:09:30
Message-ID: (view raw or whole thread)
Lists: pgsql-sql
> I did some research and can't even find a way to get meta data in a trigger.
> In a trigger, is there a way to inspect OLD and NEW to see what columns are
> there and see what has changed?  If so, you may not be able to grab the
> actual query but you could create a generic trigger that reconstructs a
> possible update/insert/delete for any table in your database.
> Does anyone know of a good place to go get information about using meta data
> in a stored procedure or trigger?

See the section "User Comments" at the very bottom of Chapter 33 after "Writing Trigger Functions
in C".  It is odd that a PL_PGSQL example is given at the end a chapter for triggers written in C.

Also see the entire chapter 36.10 "Trigger Procedures"

Hope this is what you are looking for.


Richard Broersma Jr.

In response to


pgsql-sql by date

Next:From: Forums @ ExistanzeDate: 2006-06-23 07:15:22
Subject: Re: Fwd: Start up question about triggers
Previous:From: Aaron BonoDate: 2006-06-23 03:17:43
Subject: Fwd: Start up question about triggers

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