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 Dave Cramer dave.cramer(at)credativ(dot)ca http://www.credativ.ca On 23 February 2015 at 10:49, Tom Lane <t...@sss.pgh.pa.us> wrote: > George Woodring <george.woodr...@iglass.net> 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 >
