plpgsql before insert update delete

From: "kiyo taka" <hihajime(at)hotmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: plpgsql before insert update delete
Date: 2001-12-05 05:47:05
Message-ID: F184x4A2DreBBsQwY6Y0001748b@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

hi all.

i'd like to noe how to create trigger which will insert tablez old data
into an archive table before any(insert,update,delete) operation is
executed.

i've tried "if inserting ...." but it didnt work.
is there any function that will do it?

any help will be greatly appreciated.

thanx.

_________________________________________________________________
かわいい & 使えるブラウザで、インターネット生活もっと楽しくなる!
http://explorer.msn.co.jp/

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message DI Hasenöhrl 2001-12-05 08:52:52 Re: make query faster??
Previous Message Tom Lane 2001-12-04 22:43:17 Re: Memory exhausted in AllocSetAlloc(269039)