Rename the recently-added pg_timezonenames view to pg_timezone_abbrevs,
Tom Lane <tgl@sss.pgh.pa.us>
Rename the recently-added pg_timezonenames view to pg_timezone_abbrevs, and create a new view pg_timezone_names that provides information about the zones known in the 'zic' database. Magnus Hagander, with some additional work by Tom Lane.
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/catalogs.sgml | modified | +71 −9 |
| src/backend/catalog/system_views.sql | modified | +6 −5 |
| src/backend/utils/adt/datetime.c | modified | +118 −7 |
| src/include/catalog/catversion.h | modified | +2 −2 |
| src/include/catalog/pg_proc.h | modified | +4 −2 |
| src/include/pgtime.h | modified | +6 −1 |
| src/include/utils/datetime.h | modified | +3 −2 |
| src/test/regress/expected/rules.out | modified | +3 −2 |
| src/timezone/pgtz.c | modified | +118 −1 |