Обсуждение: pgsql: Fix the various forms of AT TIME ZONE to accept either timezones
pgsql: Fix the various forms of AT TIME ZONE to accept either timezones
От
tgl@svr1.postgresql.org (Tom Lane)
Дата:
Log Message: ----------- Fix the various forms of AT TIME ZONE to accept either timezones found in the zic database or zone names found in the date token table. This preserves the old ability to do AT TIME ZONE 'PST' along with the new ability to do AT TIME ZONE 'PST8PDT'. Per gripe from Bricklen Anderson. Also, fix some inconsistencies in usage of TZ_STRLEN_MAX --- the old code had the potential for one-byte buffer overruns, though given alignment considerations it's unlikely there was any real risk. Modified Files: -------------- pgsql/doc/src/sgml: datetime.sgml (r2.46 -> r2.47) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/datetime.sgml.diff?r1=2.46&r2=2.47) func.sgml (r1.283 -> r1.284) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/func.sgml.diff?r1=1.283&r2=1.284) pgsql/src/backend/utils/adt: date.c (r1.119 -> r1.120) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/date.c.diff?r1=1.119&r2=1.120) timestamp.c (r1.151 -> r1.152) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/timestamp.c.diff?r1=1.151&r2=1.152) pgsql/src/include: pgtime.h (r1.9 -> r1.10) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/pgtime.h.diff?r1=1.9&r2=1.10) pgsql/src/timezone: pgtz.c (r1.36 -> r1.37) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/timezone/pgtz.c.diff?r1=1.36&r2=1.37)