Re: triggers and plpgsql question - Mailing list pgsql-sql

From Josh Berkus
Subject Re: triggers and plpgsql question
Date
Msg-id 200208271538.45877.josh@agliodbs.com
Whole thread Raw
In response to triggers and plpgsql question  (Mathieu Arnold <mat@mat.cc>)
Responses Re: triggers and plpgsql question
List pgsql-sql
Mathieu,

> The thing I need, is to be able to know what does NEW contains, and I have
> not found out any mean to do so. If it's not possible to do so, I'll write
> a function per table, but for the beauty of all this, I would have liked to
> do it the way above.

You can't do this in PL/pgSQL.   See the online documentation on writing
triggers in C; that is the only way to get what you want.

--
-Josh BerkusAglio Database SolutionsSan Francisco



pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: IDENT authentication problem
Next
From: "Ligia Pimentel"
Date:
Subject: Re: Problems with version 7.1, could they be fixed in 7.2?