Alexander,

>> Isn't the server supposed to disallow modifications that would lead

AVN> to

>> possible data loss?

AVN> Nando, IMO it is gbak problem. Engine don't vaste time (and
AVN> sometimes very large) to update data itself and IMO this is right.

We agree here.

>> AFAIK is does so with numerics and strings.

AVN> I'm not so sure.

If I try to convert from floating point to integer, or to decrease the
character length of a varchar column, it stops me. Accordingly,
shouldn't it do the same for timestamp -> date?

AVN> I think DATE-TIMESTAMP change should be safe too, but not
AVN> TIMESTAMP-DATE.

Yep.
Ciao
--
Nando mailto:nandod@...