Re: trouble creating trigger

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Sigi Jekabsons <sigi(dot)j(at)workskillsprofessionals(dot)com(dot)au>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: trouble creating trigger
Date: 2003-04-22 03:58:57
Message-ID: 20030421205656.V78949-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


On Tue, 22 Apr 2003, Sigi Jekabsons wrote:

> I can create the function the trigger is calling, and I can use the function
> in a SELECT, and it all works fine, but postgres won't let me create a
> trigger using that function.

Trigger functions return type trigger and take no arguments. The
arguments passed at create trigger time are specially handled.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Jim C. Nasby 2003-04-22 08:23:39 Re: [SQL] Yet Another (Simple) Case of Index not used
Previous Message Sigi Jekabsons 2003-04-22 02:28:24 trouble creating trigger