Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 5F310476006
	for <pgsql-sql@postgresql.org>; Wed, 21 Aug 2002 05:11:17 -0400 (EDT)
Received: from web40018.mail.yahoo.com (web40018.mail.yahoo.com
 [66.218.78.58])
	by postgresql.org (Postfix) with SMTP id 8773D475FB5
	for <pgsql-sql@postgresql.org>; Wed, 21 Aug 2002 05:11:16 -0400 (EDT)
Message-ID: <20020821091118.2695.qmail@web40018.mail.yahoo.com>
Received: from [203.87.150.114] by web40018.mail.yahoo.com via HTTP;
	Wed, 21 Aug 2002 02:11:18 PDT
Date: Wed, 21 Aug 2002 02:11:18 -0700 (PDT)
From: Ludwig Lim <lud_nowhere_man@yahoo.com>
Subject: Re: Trigger/Function problem
To: Andreas Johansson <andreas.johansson@cention.se>
Cc: PostgreSQL Mailing List <pgsql-sql@postgresql.org>
In-Reply-To: <CGEMKBAODBHMBJBDNABNOENOCDAA.andreas.johansson@cention.se>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200208/303
X-Sequence-Number: 9149


--- 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