db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniel John Debrunner <...@apache.org>
Subject Re: Workaround needed for nested trigger problem ERROR 54038
Date Sat, 05 Jan 2008 00:19:06 GMT
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.

Mime
View raw message