Question Regarding Unique Index on Table - Mailing list pgsql-sql

From Ozer, Pam
Subject Question Regarding Unique Index on Table
Date
Msg-id 216FFB77CBFAEE4B8EE4DF0A939FF1D10182A9@mail-001.corp.automotive.com
Whole thread Raw
Responses Re: Question Regarding Unique Index on Table
List pgsql-sql

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

Data Architect

pozer@automotive.com

tel. 949.705.3468

Source Interlink Media logo

vertical line

Source Interlink Media

1733 Alton Pkwy Suite 100, Irvine, CA 92606

www.simautomotive.com

Confidentiality Notice- This electronic communication, and all information herein, including files attached hereto, is private, and is the property of the sender. This communication is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure of; dissemination of; distribution of; copying of; or, taking any action in reliance upon this communication, is strictly prohibited. If you have received this communication in error, please immediately notify us by telephone, (949)-705-3000, and destroy all copies of this communication. Thank you.



pgsql-sql by date:

Previous
From: "Jonathan Brinkman"
Date:
Subject: Re: Proper case function
Next
From: Kenneth Marshall
Date:
Subject: Re: Question Regarding Unique Index on Table