Skip site navigation (1) Skip section navigation (2)

Writting Trigger for Truncate event

From: Jignesh Shah <jignesh(dot)shah1980(at)gmail(dot)com>
To: postgresql novice <pgsql-novice(at)postgresql(dot)org>
Subject: Writting Trigger for Truncate event
Date: 2009-08-26 06:33:01
Message-ID: c11950270908252333t6ce52427i3752369a6613a43a@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hi,

The PostgreSQL documentation says that it can be created only at statement
level and don't have any way to examine individual rows modified by
statement. I couldn't find any statement level trigger example. Though
document says statement level trigger executes when an appropriate statement
executed,  could any one please give me example of Truncate event trigger
and what is the meaning of "appropriate statement"?

Thanks,
Jignesh

pgsql-novice by date

Next:From: Michael WoodDate: 2009-08-26 07:01:56
Subject: Re: Install new perl test function in PostgreSQL
Previous:From: Jignesh ShahDate: 2009-08-26 05:06:17
Subject: Re: Install new perl test function in PostgreSQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group