From: | Kevin Davis <davisk(at)spacecybernetics(dot)com> |
---|---|
To: | Jeff Boes <jboes(at)qtm(dot)net> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Trigger and function not on speaking terms |
Date: | 2004-08-03 02:11:19 |
Message-ID: | 1091499079.28663.14.camel@spacecybernetics.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
You need to define fn_foo w/o params per Doc Section 19.9.
Your intent as expressed in the trigger def (args) can then be fulfilled
through special top level vars.
On Mon, 2004-08-02 at 16:20, Jeff Boes wrote:
> Hmm, this is puzzling me:
>
> create or replace function fn_foo(text) returns trigger as '
> begin
> # Do some stuff with $1
> end;
> ' language 'plpgsql';
>
> CREATE FUNCTION
>
> create table bar (aaa text);
>
> CREATE TABLE
>
> create trigger trg_bar
> after insert or update on bar
> execute procedure fn_foo('string');
>
> ERROR: function fn_foo() does not exist
>
> It would seem my trigger definition is trying to find fn_foo(), when I
> mean for it to call fn_foo(TEXT).
From | Date | Subject | |
---|---|---|---|
Next Message | mike g | 2004-08-03 03:31:41 | Re: error in compiling the function -- need help !!! |
Previous Message | Stephan Szabo | 2004-08-02 21:21:24 | Re: Trigger and function not on speaking terms |