The efficient method to create trigger

From: Jignesh Shah <jignesh(dot)shah1980(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: The efficient method to create trigger
Date: 2009-08-18 10:18:36
Message-ID: c11950270908180318q52dc388cg72b2c3ca2e9fe2d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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.

Could anyone please tell me which is the best way (PL/pgSQL, PL/Tcl, PL/Perl
or PL/Python). I know the Perl but not aware of Tcl and Python. It would be
great if some one could give example on processing multiple rows at once. I
am not sure how could I use spi_prepare for this.

Thanks, Jignesh

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message A. Kretschmer 2009-08-18 10:39:48 Re: The efficient method to create trigger
Previous Message Tom Lane 2009-08-15 01:09:26 Re: ORDER BY problem