KL,

> Is it safe to update the atttypid of a timestamp column to be a
> timestamptz column?  I wish to do this on a production database, so I
> need to be sure!

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.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco

Mon, 9 Aug 2004 10:00:36 -0700
Josh Berkus <josh@agliodbs.com>
Re: Changing the type of timestamp columns
> 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

Tue, 10 Aug 2004 09:16:51 +0800
Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: Changing the type of timestamp columns