Re: Dynamic Log tigger (plpgsql)

From: Noah Heusser <pgsql-general(at)heussers(dot)ch>
To: Sibte Abbas <sibtay(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Dynamic Log tigger (plpgsql)
Date: 2007-06-19 15:58:24
Message-ID: 4677FD20.6090207@heussers.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Josh 2007-06-19 16:03:46 Re: [PERFORM] Postgres VS Oracle
Previous Message Noah Heusser 2007-06-19 15:55:30 Re: Dynamic Log tigger (plpgsql)