Search Postgresql Archives

Re: Parameter passing in trigger function write in C

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



hey thanks mate, I have red that. But the actual data retirement seems to be combination of that and the SPI_get* functions. I'm still testing on it. By the way, if I can pass parameters that is out of the scope of sql statement??


------------------ Original ------------------
From: "Adrian Klaver";
Date: Friday, Apr 27, 2018 9:36 AM
To: "a"<372660931@xxxxxx>; "pgsql-general";
Subject: Re: Parameter passing in trigger function write in C

On 04/26/2018 06:13 PM, a wrote:
> Hey everyone:
>
> I was request to write a trigger that perform the following function:
>
> 1, The trigger will be set to exam all statement that will result change
> of datas
>
> 2, The trigger will exam three information other than the data updated
> or inserted: user name, password and reasons of change
>
> 3, It will record down, in some format, the time and content of the change.
>
> Therefore, I would need some way of passing parameters into the trigger
> function. Can anyone give me some instructions on how to do it or, if it
> is possible??

https://www.postgresql.org/docs/10/static/trigger-interface.html


--
Adrian Klaver
adrian.klaver@xxxxxxxxxxm

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux