Andreas Kretschmer <andreas@xxxxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
