Re: Problem creating trigger-function with arguments (8.0rc4) - Mailing list pgsql-general

From Tom Lane
Subject Re: Problem creating trigger-function with arguments (8.0rc4)
Date
Msg-id 29386.1105131135@sss.pgh.pa.us
Whole thread Raw
In response to Problem creating trigger-function with arguments (8.0rc4)  ("Florian G. Pflug" <fgp@phlo.org>)
Responses unsubscribe
Re: Problem creating trigger-function with arguments (8.0rc4)
List pgsql-general
"Florian G. Pflug" <fgp@phlo.org> writes:
> This is what I tried:

> CREATE OR REPLACE FUNCTION functions.t_insert_deny(v_message text)
> RETURNS "trigger" AS $$

There should probably be a specific error check telling you that a
trigger function can't take any explicit arguments.  But there isn't
(and it's too late for 8.0 because we froze error message strings
long since :-().

The CREATE TRIGGER parameter comes to the trigger function via TGARGS,
not as a regular parameter.

            regards, tom lane

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Problem creating trigger-function with arguments (8.0rc4)
Next
From: Ragnar Hafstað
Date:
Subject: Re: need help Connect failure in an applet