Re: Dynamic Log tigger (plpgsql) - Mailing list pgsql-general

From Noah Heusser
Subject Re: Dynamic Log tigger (plpgsql)
Date
Msg-id 4677FC72.7040107@heussers.ch
Whole thread Raw
In response to Re: Dynamic Log tigger (plpgsql)  ("Sibte Abbas" <sibtay@gmail.com>)
List pgsql-general
>> How can I do "OLD.columnName != NEW.columnName" if I don't know what the
>> columnNames are at Compile Time?
>> I have the columnName in a variable.
>
> Are you trying to do this from a plpgsql function? If so then I think
> you should try to do this from a C function.
>
> With C functions you will get more control over the new and old
> versions of the tuple since you get their pointers via
> TriggerData->tg_trigtuple (old tuple) and TriggerData->tg_newtuple
> (new tuple).
>
I think this would work. And if there is no other possibility i will do
that.
But as I saw, it is necessary to have Sysadmin rights, if you want to
add a C function.
If possible i want to do it as a regular DB-Owner.

pgsql-general by date:

Previous
From: Erik Jones
Date:
Subject: Re: Standby servers and incrementally updated backups
Next
From: Sergei Shelukhin
Date:
Subject: Re: VACUUM ANALYZE extremely slow