Re: The efficient method to create trigger

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.

 

Thanks a lot,

Jignesh

On Tue, Aug 18, 2009 at 4:09 PM, A. Kretschmer <andreas.kretschmer@schollglas.com> wrote:

In response to Jignesh Shah :

> 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.