> 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