Andres Freund <and...@2ndquadrant.com> writes: > 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. Unfortunately, the operative word in that is "noop". Didn't you see http://www.postgresql.org/message-id/11964.1395100...@sss.pgh.pa.us It would have helped before we put in the transform smarts, but now it's too smart. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
