Re: Workaround needed for nested trigger problem ERROR 54038

[Daniel John Debrunner]

Peder Hultin wrote:
FANTASTIC!!!  This idea works perfectly; thanks so much! This has 
delayed me quite a
number of hours.

For the INSERT case are you using a trigger or will a simple DEFAULT 
clause work for you? Is probably faster than a trigger.

create table t (i int, ts timestamp default current timestamp);
insert into t(i) values 1;
select * from t;

I          |TS
--------------------------------------
1          |2008-01-04 16:17:53.89


Dan.