On Sunday 05 December 2010 13:07:23 Martin Atukunda wrote: > > Due to the wonders of MVCC the old row is still available in the heap. > > Best read the docs about what MVCC means. And as pg's indexes don't care > > about visibility it will still try to index the "old" row. > > Thanks andreas, > > so, basically, the only way out of this would be to: > > 1. copy out all the rows > 2. truncate the Tables > 3. then create the index > 4. copy in the rows Something like:
ALTER TABLE t ALTER apps TYPE text[]; ALTER TABLE t ALTER apps TYPE bigint[] USING apps::bigint[]; could work. Andres -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
