Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id 5C3DC1337B4F
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Thu, 23 Sep 2010 15:33:11 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 85527-04 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Thu, 23 Sep 2010 18:33:04 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from mh3.mail.rice.edu (mh3.mail.rice.edu [128.42.199.10])
	by mail.postgresql.org (Postfix) with ESMTP id E49711337B50
	for <pgsql-sql@postgresql.org>; Thu, 23 Sep 2010 15:33:03 -0300 (ADT)
Received: from mh3.mail.rice.edu (localhost.localdomain [127.0.0.1])
	by mh3.mail.rice.edu (Postfix) with ESMTP id 6CAB228F6CE;
	Thu, 23 Sep 2010 13:33:03 -0500 (CDT)
X-Virus-Scanned: by amavis-2.6.4 at mh3.mail.rice.edu, auth channel
Received: from mh3.mail.rice.edu ([127.0.0.1])
	by mh3.mail.rice.edu (mh3.mail.rice.edu [127.0.0.1]) (amavis,
	port 10026)
	with ESMTP id PxB5fkCmC6Nl; Thu, 23 Sep 2010 13:33:03 -0500 (CDT)
X-SMTP-Auth: no
X-SMTP-Auth: no
Received: from aart.is.rice.edu (aart.is.rice.edu [168.7.56.48])
	by mh3.mail.rice.edu (Postfix) with ESMTP id 3CBA628F6C7;
	Thu, 23 Sep 2010 13:33:03 -0500 (CDT)
Received: by aart.is.rice.edu (Postfix, from userid 18612)
	id B3B252D5A6; Thu, 23 Sep 2010 13:33:02 -0500 (CDT)
Date: Thu, 23 Sep 2010 13:33:02 -0500
From: Kenneth Marshall <ktm@rice.edu>
To: "Ozer, Pam" <pozer@automotive.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Question Regarding Unique Index on Table
Message-ID: <20100923183302.GB17736@aart.is.rice.edu>
References: 
 <216FFB77CBFAEE4B8EE4DF0A939FF1D10182A9@mail-001.corp.automotive.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: 
 <216FFB77CBFAEE4B8EE4DF0A939FF1D10182A9@mail-001.corp.automotive.com>
User-Agent: Mutt/1.5.16 (2007-06-09)
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-4.21 tagged_above=-5 required=5 tests=BAYES_00=-1.9,
	RCVD_IN_DNSWL_MED=-2.3, T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: 
X-Archive-Number: 201009/91
X-Sequence-Number: 34622

9.0 allows you to defer unique constraints.

Ken

On Thu, Sep 23, 2010 at 10:18:39AM -0700, Ozer, Pam wrote:
> Is it possible to disable a unique index?  I have a process that's
> running that inserts duplicate records into a table and then does a
> cleanup afterwards.  I know that I can drop the index and rebuild.  I
> just didn't know if there was disable the uniqueness temporarily.
> 
>  
> 
> thanks
> 
>  
> 
> Pam Ozer