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

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