Re: index doesn't contain duplicates

From: Adric Norris <>
Date: Tue, 9 Jun 2009 16:07:58 -0500
Message-ID: <>

On Tue, Jun 9, 2009 at 1:11 PM, Josh Collier <>wrote:

> Table was created with a CTAS
> Non-unique index was built
> Primary key was built on a column, specifying index created in step2.
> Enable novalidate. The data in question was inserted after the primary was
> in place.

Are you *absolutely* certain that the data wasn't preexisting? The combination of a nonunique index and novalidate on the PK constraint seems like it could easily explain the observed behavior.

"I'm too sexy for my code." - Awk Sed Fred.

Received on Tue Jun 09 2009 - 16:07:58 CDT

Original text of this message