From: Ludwig Lim <lud_nowhere_man@yahoo.com>
To: Andreas Johansson <andreas.johansson@cention.se>
Cc: PostgreSQL Mailing List <pgsql-sql@postgresql.org>
Subject: Re: Trigger/Function problem
Date: Wed, 21 Aug 2002 02:11:18 -0700 (PDT)
Message-ID: <20020821091118.2695.qmail@web40018.mail.yahoo.com> (raw)
In-Reply-To: <CGEMKBAODBHMBJBDNABNOENOCDAA.andreas.johansson@cention.se>
--- 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: lud_nowhere_man@yahoo.com, andreas.johansson@cention.se
Subject: Re: Trigger/Function problem
In-Reply-To: <20020821091118.2695.qmail@web40018.mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox