postgresql/contrib/postgres_fdw
Tom Lane a3021aafce Make postgres_fdw request remote time zone 'GMT' not 'UTC'.
This should have the same results for all practical purposes.
The advantage of selecting 'GMT' is that it's guaranteed to work
even when the remote system's timezone database is missing
entries, because pg_tzset() hard-wires handling of that,
at least in 9.2 and later.

(It seems like it would be a good idea to similarly hard-wire
correct handling of 'UTC', but that'll be a little more invasive
than I want to consider back-patching.  Leave that for another
day when we're not in feature freeze.)

Per trouble report from Adnan Dautovic.  Back-patch to all
supported branches.

Discussion: https://postgr.es/m/465248.1712211585@sss.pgh.pa.us
2024-04-21 13:46:20 -04:00
..
expected Stabilize postgres_fdw test 2024-03-30 14:16:54 +01:00
sql Stabilize postgres_fdw test 2024-03-30 14:16:54 +01:00
.gitignore Add postgres_fdw contrib module. 2013-02-21 05:27:16 -05:00
Makefile postgres_fdw: Add function to list cached connections to foreign servers. 2021-01-18 15:11:08 +09:00
connection.c Make postgres_fdw request remote time zone 'GMT' not 'UTC'. 2024-04-21 13:46:20 -04:00
deparse.c Fixup various StringInfo function usages 2024-04-10 11:53:32 +12:00
meson.build Update copyright for 2024 2024-01-03 20:49:05 -05:00
option.c Update copyright for 2024 2024-01-03 20:49:05 -05:00
postgres_fdw--1.0--1.1.sql postgres_fdw: Add functions to discard cached connections. 2021-01-26 15:35:54 +09:00
postgres_fdw--1.0.sql Add postgres_fdw contrib module. 2013-02-21 05:27:16 -05:00
postgres_fdw.c postgres_fdw: Improve comment about handling of asynchronous requests. 2024-04-11 19:25:00 +09:00
postgres_fdw.control postgres_fdw: Add function to list cached connections to foreign servers. 2021-01-18 15:11:08 +09:00
postgres_fdw.h Make dblink interruptible, via new libpqsrv APIs. 2024-01-08 11:39:56 -08:00
shippable.c Update copyright for 2024 2024-01-03 20:49:05 -05:00