Re: Updating timezone setting

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 converting is that timestamp with timezone anchors the
> time and you do not have to worry as much, about what the
> application is doing. That being said, I could see rolling that out
> over time:)

Sorry to be late on this, but since the data is already stored in GMT,
you might be able to just change the system catalogs to say timestamp
with time zone.  I recommend you find a PG expert to research this and
test it.

-- 
  Bruce Momjian          http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + Everyone has their own god. +