Search Postgresql Archives

Re: Column type changed "spontanously"?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thursday, May 9, 2019, Chuck Martin <clmartin@xxxxxxxxxxxxxxxx> wrote:
I have several columns that were created as "timestamp without time zone", but I changed them in 2014 to "timestamp with time zone". Recently, when I got notified that times had suddenly changed, I checked and found the columns had reverted to "timestamp without time zone." This seems impossible, yet it seems to have happened. Any ideas on what could cause this? My application has the privileges to do this, as it changed the data type to support time zones. But there is no code that could change it back not to support time zones.

No clue
 

The database in on

"PostgreSQL 9.3.1 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-3), 64-bit" 

Given the issues with the early 9.3 releases running 9.3.1 is a extremely unwise decision.  Beyond the unwise-ness of not keeping up with minor releases generally.
 
What other information would help solve this?

Log files containing DDL commands

 David J.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux