Re: Changing the type of timestamp columns - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: Changing the type of timestamp columns
Date
Msg-id 41182203.7020501@familyhealth.com.au
Whole thread Raw
In response to Re: Changing the type of timestamp columns  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
> I wouldn't try this without running it against a test database copy first.  
> I've already discovered that a backend change to a column data type like your 
> describing can disrupt indexes, views, and analyze rows based on the table -- 
> the last time I did such, I ended up having to dump and reload the database 
> to get everything responding reliably.

Yeah, I just remembered table types and pg_depend entries, so I'm not 
really keen to do it any more :/

Chris


pgsql-hackers by date:

Previous
From: "Gavin M. Roy"
Date:
Subject: 8.0 Beta Thank You
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: Tablespace issues (comment on ,moving indexes)