Re: Getting the function definition from oid in before firing the function

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