> Could you describe the scenario you're thinking of that you think could 
> be problematic.

Well, I was mostly thinking what would happen is suddenly some dates become 
colliding in UTC in i.e. unique index and you rebuild the index. It was fine 
before, but it's not now.

But it could be also something like:
insert <some date> 15:00 in foo/bar (+3)
TZ database change, where "foo/bar" becomes +2
insert <some date> 15:00 in foo/bar (+2)

Same local time, but different UTC, hence no unique violation. Is that the 
expected experience? Or when "insert <some date> 14:00 in foo/bar (+2)" and the 
unique constraint is gonna complain, although it's different local time. Again, 
is that the expected experience?

-- 
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/



Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to