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(dot)kretschmer(at)schollglas(dot)com> wrote:

> In response to Jignesh Shah :
> > Hi,
> >
> > I am new to PostgreSQL. I learnt most of things from postgresql.orgsite. 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.
>
> 12:32 < akretschmer> ??tablelog
> 12:32 < rtfm_please> For information about tablelog
> 12:32 < rtfm_please> see
> http://andreas.scherbaum.la/blog/archives/100-Log-Table-Changes-in-PostgreSQL-with-tablelog.html
> 12:32 < rtfm_please> or http://pgfoundry.org/projects/tablelog/
>
> Regards, Andreas
> --
> Andreas Kretschmer
> Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
> GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>