NOTIFY from PL/pgSQL trigger procedure - Mailing list pgsql-general

From Mikhail Terekhov
Subject NOTIFY from PL/pgSQL trigger procedure
Date
Msg-id 3992C148.DB7B748F@emc.com
Whole thread Raw
Responses Re: NOTIFY from PL/pgSQL trigger procedure  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hi,

Is it possible to use variable as a notify name inside PL/pgSQL trigger
procedure? I'd like to create generic function like this:

CREATE FUNCTION send_notify() RETURNS OPAQUE AS '
DECLARE
    notifyname text;
BEGIN
    notifyname := TG_RELNAME || TG_OP;
    NOTIFY notifyname;
    RETURN NULL;
END;
' LANGUAGE 'plpgsql';

CREATE TRIGGER notify_trigger AFTER INSERT OR UPDATE ON test FOR EACH ROW
    EXECUTE PROCEDURE send_notify();

But when this procedure is called I'm getting an error:

ERROR:  parser: parse error at or near "$1"

What is wrong here?

Regards,
Mikhail

pgsql-general by date:

Previous
From: Philip Hallstrom
Date:
Subject: Re: PSQL woes
Next
From: Louis-David Mitterrand
Date:
Subject: problem with float8 input format