On 2014-03-18 19:28:53 +0000, Greg Stark wrote:
> It would be nice to be able to tell people that if they vacuum, then
> reindex and check all their foreign key constraints then they should
> be ok.
I don't think so:
http://archives.postgresql.org/message-id/20140317233919.GS16438%40awork2.anarazel.de
I still think a rewriting noop ALTER TABLE ... ALTER COLUMN col TYPE
old_type USING (col); is the only real thing to do.
Greetings,
Andres Freund
--
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services