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

<div class="WordSection1"><p class="MsoNormal">Is it possible to disable a unique index?  I have a process that’s
runningthat inserts duplicate records into a table and then does a cleanup afterwards.  I know that I can drop the
indexand rebuild.  I just didn’t know if there was disable the uniqueness temporarily.<p class="MsoNormal"> <p
class="MsoNormal">thanks<pclass="MsoNormal"> <div id="content"><p class="MsoNormal"><b><span
style="font-size:11.5pt;font-family:"Arial","sans-serif";
color:black">Pam Ozer</span></b><p class="MsoNormal"><i><span style="font-size:10.5pt;font-family:"Arial","sans-serif";
color:black">Data Architect</span></i><p class="MsoNormal"><span
style="font-size:9.0pt;font-family:"Arial","sans-serif";
color:black"><a href="mailto:pozer@automotive.com"><span style="color:blue">pozer@automotive.com</span></a>
</span><tableborder="0" cellpadding="0" class="MsoNormalTable"><tr><td style="padding:0in 0in 0in 0in"><p
class="MsoNormal"><b><spanstyle="font-size:9.0pt;font-family:"Arial","sans-serif"; color:black">tel.</span></b><span
style="font-size:9.0pt;font-family:"Arial","sans-serif";color:black"> 949.705.3468</span></td></tr></table></div><table
border="0"cellpadding="0" cellspacing="0" class="MsoNormalTable" style="width:100.0%" width="100%"><tr
style="height:39.0pt"><tdstyle="width:79.5pt;padding:0in 0in 0in 0in;height:39.0pt" width="106"><p align="center"
class="MsoNormal"style="text-align:center"><span
style="font-size:9.0pt;font-family:"Arial","sans-serif";color:black"><imgalt="Source Interlink Media logo" border="0"
height="52"id="_x0000_i1026" src="cid:image001.jpg@01CB5B08.B0FA49D0" width="106" /></span><span
style="font-size:9.0pt;font-family:"Arial","sans-serif";color:black"></span></td><tdstyle="width:3.75pt;padding:7.5pt
7.5pt7.5pt 7.5pt;height:39.0pt" width="5"><p align="center" class="MsoNormal" style="text-align:center"><span
style="font-size:9.0pt;font-family:"Arial","sans-serif";color:black"><imgalt="vertical line" border="0" height="50"
id="_x0000_i1025"src="cid:image002.jpg@01CB5B08.B0FA49D0" width="1" /></span><span
style="font-size:9.0pt;font-family:"Arial","sans-serif";color:black"></span></td><tdstyle="padding:0in 0in 0in
0in;height:39.0pt"><pclass="MsoNormal"><b><i><span style="font-size:10.5pt;font-family:"Arial","sans-serif";
color:black">SourceInterlink Media</span></i></b><p class="MsoNormal"><span
style="font-size:9.0pt;font-family:"Arial","sans-serif";color:black">1733 Alton Pkwy Suite 100, Irvine, CA
92606</span><pclass="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial","sans-serif"; color:black"><a
href="http://www.simautomotive.com"><spanstyle="color:blue">www.simautomotive.com</span></a>
</span></td></tr></table><divid="confid_notice" style="border:none;border-top:solid #D4D4D4 1.0pt;padding:8.0pt 0in 0in
0in"><pclass="MsoNormal"><i><span style="font-size:9.0pt;font-family:"Arial","sans-serif"; 
color:#CDCDCD">Confidentiality Notice- This electronic communication, and all information herein, including files
attachedhereto, is private, and is the property of the sender. This communication is intended only for the use of the
individualor entity named above. If you are not the intended recipient, you are hereby notified that any disclosure of;
disseminationof; 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,
anddestroy all copies of this communication. Thank you.</span></i></div><p class="MsoNormal"><span
style="font-size:12.0pt;font-family:"TimesNew Roman","serif""><br /><br /></span></div>