For posterity please be aware this will very likely break any timestamps transfer using JDBC and binary transfer.
This is not recommended for general consumption
On 23 February 2015 at 10:49, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
George Woodring <george.woodring@xxxxxxxxxx> writes:
> Yes, that is where we think we are heading, the issue is that the code does
> not know what it needs to be set back to. We have 90 databases with 5
> different time zones. I was just hoping for a more elegant solution than
> writing a lookup table that says if you are connecting to db x then set to
> timezone y.
"RESET timezone" ?
regards, tom lane