can not create trigger with parameter

From: "Rahul Patil" <rg_patil(at)rediffmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: can not create trigger with parameter
Date: 2005-12-15 12:56:30
Message-ID: 20051215125630.7907.qmail@webmail28.rediffmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,

I'm having trouble getting a trigger to use a parameter, as in the
following simplified example:

CREATE FUNCTION fun_version_table(varchar)
RETURNS opaque
AS 'DECLARE

in_table_name ALIAS FOR $1;
v_counter integer;

BEGIN
SELECT INTO v_counter counter FROM version_table
WHERE table_name = in_table_name;
-- do something in here
RETURN new;
END;'
LANGUAGE 'plpgsql';

CREATE TRIGGER trig_deg_master
AFTER
INSERT OR UPDATE OR DELETE
ON author
FOR EACH ROW
EXECUTE PROCEDURE fun_version_table('degree_master');

Function gets created successfully.But
when I create trigger I get an error:

ERROR:CreateTrigger: function fun_version_table() does not exist

I've created triggers/functions with no parameters and they work fine.

The Postgresql book has some examples of functions with paramters, but
I cannot find anywhere a trigger which calls a function with parameters,

although the users manual indicates that parameters are allowed in the
syntax for CREATE TRIGGER.
 

Regards,
Rahul

Browse pgsql-novice by date

  From Date Subject
Next Message Doug 2005-12-15 14:09:24 How populate : variables dynamically?
Previous Message me 2005-12-15 12:04:47 Re: GUID function in pgsql?