Re: Trigger/Function problem - Mailing list pgsql-sql

From Ludwig Lim
Subject Re: Trigger/Function problem
Date
Msg-id 20020821091118.2695.qmail@web40018.mail.yahoo.com
Whole thread Raw
In response to Trigger/Function problem  ("Andreas Johansson" <andreas.johansson@cention.se>)
List pgsql-sql
--- Andreas Johansson <andreas.johansson@cention.se> >

> ERROR:  CreateTrigger: function fix_status() does
> not exist
Andreas :

> 
> Why doesn't the trigger acknowledge that I want to
> call fix_status with a
> parameter for which table name I should use?
> 
> I'm completely stuck and I someone out there can
> help me.
 - Trigger procedures cannot have paramaters. Use the
variable TG_ARGV[] to access the arguments passed to
the trigger.

ludwig. 


__________________________________________________
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com


pgsql-sql by date:

Previous
From: "Andreas Johansson"
Date:
Subject: Trigger/Function problem
Next
From: Bhuvan A
Date:
Subject: Re: Trigger/Function problem