CREATE FUNCTION test_trigger() RETURNS TRIGGER AS

$

    plv8.elog(NOTICE, "NEW = ", JSON.stringify(NEW));

    plv8.elog(NOTICE, "OLD = ", JSON.stringify(OLD));

    plv8.elog(NOTICE, "TG_OP = ", TG_OP);

    plv8.elog(NOTICE, "TG_ARGV = ", TG_ARGV);

    if (TG_OP == "UPDATE") {

        NEW.i = 102;

        return NEW;

    }

$

LANGUAGE "plv8";

​

CREATE TRIGGER test_trigger

    BEFORE INSERT OR UPDATE OR DELETE

    ON test_tbl FOR EACH ROW

    EXECUTE PROCEDURE test_trigger('foo', 'bar');

NEW

OLD

TG_NAME

TG_WHEN

TG_LEVEL

TG_OP

TG_RELID

TG_TABLE_NAME

TG_TABLE_SCHEMA

TG_ARGV