Re: [SQL] Trigger/Function problem

2002-08-21 Thread Bhuvan A
On Wed, 21 Aug 2002, Andreas Johansson wrote: > Hi all, > > I have a slight problem using triggers and functions in PostGreSQL. I'm > currently running PostGreSQL 7.2.1 on a RedHat 7.2. I've compiled the > sources (no rpm installation). > > I have several different tables and in each table ther

Re: [SQL] Trigger/Function problem

2002-08-21 Thread Ludwig Lim
--- Andreas Johansson <[EMAIL PROTECTED]> > > 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

[SQL] Trigger/Function problem

2002-08-21 Thread Andreas Johansson
Hi all, I have a slight problem using triggers and functions in PostGreSQL. I'm currently running PostGreSQL 7.2.1 on a RedHat 7.2. I've compiled the sources (no rpm installation). I have several different tables and in each table there's a status flag that's telling if a row is deleted or not (