Hi guys,
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!
Thanks,
Chris
---(end of broadcast)---
TIP 2: you can get off all lists at once with
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
---(end of
Christopher Kings-Lynne [EMAIL PROTECTED] writes:
Is it safe to update the atttypid of a timestamp column to be a
timestamptz column?
For sufficiently small values of safe, sure.
The problem is that unless you live in GMT zone, the interpretation
of values is different: the zero reference for
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
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