Question Regarding Unique Index on Table
От | Ozer, Pam |
---|---|
Тема | Question Regarding Unique Index on Table |
Дата | |
Msg-id | 216FFB77CBFAEE4B8EE4DF0A939FF1D10182A9@mail-001.corp.automotive.com обсуждение исходный текст |
Ответы |
Re: Question Regarding Unique Index on Table
(Kenneth Marshall <ktm@rice.edu>)
|
Список | 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>
В списке pgsql-sql по дате отправления: