Is it possible to stop the trigger execution for a moment?

From: "Piotr Sroczynski" <piotr(at)m1(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Is it possible to stop the trigger execution for a moment?
Date: 2001-09-23 10:07:32
Message-ID: 9okjnf$4ki$1@news.tpi.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All,

I want to have table with all rows numbered from 1 to number_of_rows without
any holes. It shoud be true all the time: after delete, modify and insert
operations.

The obvious solution are triggers but to write the procedure I need
something to stop recursive trigger execution. Is it possible? If not how
could I solve the problem?

Thanks in advance,

Please send replay to my e-mail,

Piotr Sroczynski

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2001-09-23 11:43:19 Re: Multibyte FAQ item
Previous Message Russ McBride 2001-09-23 09:39:27 printing SQL history newbie question