[BUGS] PL/pgSQL triggers with parameters don't work

[pgsql-bugs]

José María Fernández González ([EMAIL PROTECTED]) reports a bug with a severity 
of 2
The lower the number the more severe it is.

Short Description
PL/pgSQL triggers with parameters don't work

Long Description
        The report is for PostgreSQL 7.1.2. When you create a trigger which calls a 
function with parameters, the system links against the function with the same name and 
no parameter, and if it doesn't exist it tells "function doesn't exist". Tests have 
been made with PL/pgSQL-encoded functions.

Sample Code
CREATE table a(
        b INTEGER,
        c TEXT
);

CREATE FUNCTION cascaya (INTEGER) RETURNS OPAQUE AS '
DECLARE
        value ALIAS FOR $1;
BEGIN
        IF value > 0
        THEN
                RAISE EXCEPTION ''Value: %'',value;
        END IF;
        return NULL;
END;
' LANGUAGE 'plpgsql';

CREATE TRIGGER case1 BEFORE INSERT
ON a FOR EACH ROW
EXECUTE PROCEDURE cascaya(5);

ERROR:  CreateTrigger: function cascaya() does not exist                               
             

CREATE FUNCTION cascaya () RETURNS OPAQUE AS '
BEGIN
        return NULL;
END;
' LANGUAGE 'plpgsql';

CREATE TRIGGER case2 BEFORE INSERT
ON a FOR EACH ROW
EXECUTE PROCEDURE cascaya(5);

select proname,pronargs,oid from pg_proc where proname='cascaya';

 proname | pronargs |   oid
---------+----------+---------
 cascaya |        0 | 1050555
 cascaya |        1 | 1050554

select tgname,tgfoid,tgnargs from pg_trigger where tgname='case2';

 tgname | tgfoid  | tgnargs
--------+---------+---------
 case2  | 1050555 |       1



No file was uploaded with this report


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly