Postgres Pro
Downloads
Home   >   mailing lists

Is it possible to stop the trigger execution for a moment? - Mailing list pgsql-general

From Piotr Sroczynski
Subject Is it possible to stop the trigger execution for a moment?
Date
Msg-id 3BADF18D.15093.D2A24@localhost
Whole thread Raw
List pgsql-general
Tree view 
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,
Piotr Sroczynski


pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Multibyte FAQ item
Next
From: "Piotr Sroczynski"
Date:
Subject: Is it possible to stop the trigger execution for a moment?