Re: Trigger and function not on speaking terms

From: Richard Poole <rp(at)guests(dot)deus(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Trigger and function not on speaking terms
Date: 2004-08-02 21:20:31
Message-ID: 20040802212031.GA20726@guests.deus.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2004-08-02 21:21:24 Re: Trigger and function not on speaking terms
Previous Message Jeff Boes 2004-08-02 20:20:15 Trigger and function not on speaking terms