Andres,
> There's zap chance of doing anything for 9.3, this would require quite a
> bit of code in tablecmds.c and that surely isn't going to happen in the
> backbranches.
Oh, sure, I was thinking of a workaround.
Actually, being able to separate "need to check contents" from "need to
rewrite values" could be useful for a lot of type conversions.
I'd also love some way of doing a no-rewrite conversion between
timestamp and timestamptz, based on the assumption that the original
values are UTC time. That's one I encounter a lot.
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com