Thanks but I already read about everything about PostgrSQL and don't want to read LogTable. Could any one please give me or point me some of Perl or C trigger examples that uses spi_prepare.
> Hi, > > I am new to PostgreSQL. I learnt most of things from postgresql.org site. I > want to write a trigger for on my table tech_projects such that whenever > INSERT, UPDATE or DELETE happen on this table, the trigger should get called > and the updated/deleted row must be added to tech_projects_backup table. > Moreover, if there are more than one row updated then I don't want to reiterate > the client-server communication for each row but instead it should process all > rows at once.
Triggers operate on the server only. There is no client-server communication for executing a trigger at the row level or at the statement level.
