Re: index doesn't contain duplicates
- From: Adric Norris <spikey.mcmarbles@xxxxxxxxx>
- To: Josh.Collier@xxxxxxxxxxxx
- Date: Tue, 9 Jun 2009 16:07:58 -0500
On Tue, Jun 9, 2009 at 1:11 PM, Josh Collier <Josh.Collier@xxxxxxxxxxxx>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.
Other related posts:
