truncate trigger query

From: Jignesh Shah <jignesh(dot)shah1980(at)gmail(dot)com>
To: postgresql novice <pgsql-novice(at)postgresql(dot)org>
Subject: truncate trigger query
Date: 2009-09-15 05:13:34
Message-ID: c11950270909142213t70470b84o1505fea4a87b5878@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,

Could anyone please tell me if there is any way to know in perlpl whether
truncate trigger invoked on empty table? Actually, I am updating my log
table on truncate operation on my main table. If truncate query executed on
empty main table then trigger should not update any rows in log table. Any
help would be really helpful.

Thanks,
Jignesh

Browse pgsql-novice by date

  From Date Subject
Next Message Jasen Betts 2009-09-16 12:43:18 Re: Download postgresql 7.4.1 windows
Previous Message guillaume lemire 2009-09-14 23:10:05 Missing password