On 14-5-2018 09:13, Simonov Denis via Firebird-devel wrote:
Adriano dos Santos Fernandes <adrian...@gmail.com> wrote Thu, 10 May 2018 18:21:49 +0300:

Hi!

I want to create a virtual table that lists available time zones.

For now there is RDB$ (non-virtual), MON$ (virtual, but all about
monitoring), SEC$ (security plugin).

What prefix should TIME_ZONES have?

Adriano


I'm wondering how the time zones will be updated?
Will they be distributed as a separate file in Firebird?
Can I register a new rule for time zones without updating Firebird and the backup/restore process?
If so, is there a DLL syntax for registering a new time zone rule?

If you look at PostgreSQL, they release a new point release with updated time zone data. I don't see why we need to make this more complicated than that.

However that does mean, that we need to have a quick turn-around time for new releases (especially given the annoying habit of some countries of making changes like this on short notice). If we can't do that, we will need to provide some way to make update the time zone data easily(!). No hacks or requiring users to recompile ICU or anything like that.

Mark
--
Mark Rotteveel

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to