> 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 - Martin -