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 9okjnf$4ki$1@news.tpi.pl
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,

Please send replay to my e-mail,

Piotr Sroczynski

pgsql-general by date:

Previous
From: "Piotr Sroczynski"
Date:
Subject: Is it possible to stop the trigger execution for a moment?
Next
From: Chris
Date:
Subject: Re: creating "user" table