On 1/5/16 8:13 AM, Mohammed Ajil wrote:
Now my problem consists of two steps: - First I need to decide if the algorithm supports the trigger type (only of LANGUAGE PLPGSQL).
plpgsql is NOT the only language that supports triggers.
- Second I need to get the SQL command that the function will execute. What I tried was the following: In the file trigger.c I have found the location where the function is called.
I think triggers is the wrong way to approach this; it's full of holes (not the least of which is triggers don't fire on SELECT). You'd be much better off with an executor hook.
Have you looked at https://github.com/2ndQuadrant/pgaudit? -- Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX Experts in Analytics, Data Architecture and PostgreSQL Data in Trouble? Get it in Treble! http://BlueTreble.com -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
