Foreign key on timezone with current utc offset
We have a table timezones which is essentially a copy of the pg_timezone_names view. After the world changed the clocks past weekend, the utc_offset in our table is not correct anymore. Since the pg_timezone_names view is just a view, we cannot reference it. Ofc one option would be a cron job that runs twice a year and refreshes the copy. Is there any way to just reference a pg-provided table that contains the tz name with its current utc_offset instead?
