Yep, I wanna pass the brief reason of manipulating(update, insert or delete), name and password of the manipulator (This might be done by database itself).
------------------ Original ------------------ From: "Adrian Klaver"; Date: Friday, Apr 27, 2018 10:16 PM To: "a"<372660...@qq.com>; "pgsql-general"; Subject: Re: Parameter passing in trigger function write in C On 04/26/2018 06:48 PM, a wrote: > 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?? Can you be more specific about what parameters you are looking to pass in? > > > ------------------ Original ------------------ > *From:* "Adrian Klaver"; > *Date:* Friday, Apr 27, 2018 9:36 AM > *To:* "a"<372660...@qq.com>; "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 > <https://www.postgresql.org/docs/10/static/trigger-interface.html>; > > > -- > Adrian Klaver > adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com> -- Adrian Klaver adrian.kla...@aklaver.com