| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Andreas Kretschmer <andreas(at)a-kretschmer(dot)de> |
| Cc: | susan(dot)hurst(at)brookhurstdata(dot)com, Melvin Davidson <melvin6925(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Calling function (table_name, schema_name) within event trigger |
| Date: | 2015-12-27 19:19:07 |
| Message-ID: | 4353.1451243947@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Andreas Kretschmer <andreas(at)a-kretschmer(dot)de> writes:
> The problem is, that tg_table_name isn't declared within a event trigger.
> TG_TAG is defined, it contains the command, for instance CREATE TABLE.
Yeah. According to
http://www.postgresql.org/docs/9.4/static/plpgsql-trigger.html#PLPGSQL-EVENT-TRIGGER
only TG_TAG and TG_EVENT are defined inside PL/pgSQL event triggers.
So at present, you can only do very coarse event recording using
PL/pgSQL; if you want to do anything interesting you have to resort
to writing your event trigger in C. (And I think that even then,
9.4 did not offer very complete facilities for finding out what the
DDL command had done; 9.5 will provide more info.)
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andreas Kretschmer | 2015-12-27 20:14:22 | Re: Calling function (table_name, schema_name) within event trigger |
| Previous Message | Andreas Kretschmer | 2015-12-27 19:12:00 | Re: Calling function (table_name, schema_name) within event trigger |