CREATE OR REPLACE FUNCTION tr_test1()
  RETURNS "trigger" AS
$BODY$DECLARE
	query text;     
BEGIN
	IF (TG_OP = 'UPDATE') THEN
	--INSERT INTO test_audit SELECT 'U', now(), user, OLD.*;

	SELECT OLD.* Into temporary old_temp;
	
	query := 'insert into ' ||TG_RELNAME|| '_audit select ' || quote_literal('u') ||',  now(), user, old_temp.* ;';
	--query := 'insert into ' ||TG_RELNAME|| '_audit select ' || quote_literal('u') ||',  now(), user, old.* ;';
        EXECUTE query;
	DROP table old_temp;
	END IF;
        RETURN NEW;

END;$BODY$
  LANGUAGE 'plpgsql' VOLATILE;
ALTER FUNCTION tr_test1() OWNER TO pgsql;