Re: [Trigger] Help needed with NEW.* and TG_TABLE_NAME - Mailing list pgsql-sql

From Tom Lane
Subject Re: [Trigger] Help needed with NEW.* and TG_TABLE_NAME
Date
Msg-id 6038.1273587810@sss.pgh.pa.us
Whole thread Raw
In response to [Trigger] Help needed with NEW.* and TG_TABLE_NAME  (Torsten Zühlsdorff <foo@meisterderspiele.de>)
Responses Re: [Trigger] Help needed with NEW.* and TG_TABLE_NAME  (Torsten Zühlsdorff <foo@meisterderspiele.de>)
List pgsql-sql
Torsten Zühlsdorff <foo@meisterderspiele.de> writes:
>    NEW.revision := addContentRevision (OLD.content_id, OLD.revision);

>    /* not working line, just a stub:
>    EXECUTE 'INSERT INTO ' || TG_TABLE_NAME  || ' SELECT $1 ' USING NEW;
>    */

>    RETURN NULL;

This seems like the hard way.  Why don't you just RETURN NEW and let the
normal insertion happen?
        regards, tom lane


pgsql-sql by date:

Previous
From: Torsten Zühlsdorff
Date:
Subject: [Trigger] Help needed with NEW.* and TG_TABLE_NAME
Next
From: Torsten Zühlsdorff
Date:
Subject: Re: [Trigger] Help needed with NEW.* and TG_TABLE_NAME