On Dec 29, 2010, at 11:16 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> I really really dislike the notion of a "verification scan": it's
> basically work that is going to be useless if it fails.
I think it has potential in cases like text to xml. In that case it'll either work or fail, with no possibility of requiring a do-over. Scanning the whole table is a whole lot cheaper than rewriting it. But I agree with your assessment of the "optimistic" verification scan case.
...Robert