Re: Column type changed "spontanously"?

On 5/9/19 6:14 AM, Chuck Martin 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.
> 
> 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"
> 
> What other information would help solve this?

Assuming you have log_statement set to ddl or higher and the logs still 
exist I would look in them for an ALTER TABLE ... statement on that column.

> 
> Chuck Martin
> Avondale Software


-- 
Adrian Klaver
adrian.klaver@aklaver.com