Postgres Pro
Downloads
Home   >   mailing lists

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 411736E2.8020705@familyhealth.com.au
Whole thread Raw
In response to Changing the type of timestamp columns  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-hackers
Tree view 
> 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!

Oh, and what about indexes on them?  Do I just drop them beforehand and 
recreate?

Chris

pgsql-hackers by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Changing the type of timestamp columns
Next
From: Christopher Kings-Lynne
Date:
Subject: Analyze using savepoints?