db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Peder Hultin" <peder.hul...@gmail.com>
Subject Re: Workaround needed for nested trigger problem ERROR 54038
Date Sat, 05 Jan 2008 05:19:43 GMT
Yes, I'll probably be using default value on the insert but not certain yet.
Thanks for the advice.

-Peder


On Jan 4, 2008 4:19 PM, Daniel John Debrunner <djd@apache.org> wrote:

> 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