Postgres Pro
Downloads
Home   >   mailing lists

Re: Trigger and function not on speaking terms - Mailing list pgsql-sql

From Richard Poole
Subject Re: Trigger and function not on speaking terms
Date
Msg-id 20040802212031.GA20726@guests.deus.net
Whole thread Raw
In response to Trigger and function not on speaking terms  (Jeff Boes <jboes@qtm.net>)
List pgsql-sql
Tree view 
On Mon, Aug 02, 2004 at 04:20:15PM -0400, Jeff Boes wrote:

> It would seem my trigger definition is trying to find fn_foo(), when I 
> mean for it to call fn_foo(TEXT).

Triggers have to be declared to take no arguments; they find the rows on
which they operate in magical ways. (For PL/PgSQL triggers, see chapter
37.10 of the manual.)

Richard

pgsql-sql by date:

Previous
From: Jeff Boes
Date:
Subject: Trigger and function not on speaking terms
Next
From: Stephan Szabo
Date:
Subject: Re: Trigger and function not on speaking terms