On Mon, Nov 10, 2014 at 05:09:10PM -0800, Adrian Klaver wrote:
> >Would there be any issues then just leaving the columns as "timestamp
> >without time zone"? I know that's not ideal, but that would be a big
> >project to try and convert every single one of those columns.
>
> The plus for converti
On 11/10/2014 02:04 PM, Keith Fiske wrote:
Discovered that a client of ours had assumed their database was running
in UTC, but turned out to be running in 'US/Eastern'. They had changed
all their systems a while ago to run in UTC but didn't realize the
database was independent of that. The postgr
Discovered that a client of ours had assumed their database was running in
UTC, but turned out to be running in 'US/Eastern'. They had changed all
their systems a while ago to run in UTC but didn't realize the database was
independent of that. The postgresql.conf has
timezone = 'US/Eastern'
set i
