pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Question Regarding Unique Index on Table
2+ messages / 2 participants
[nested] [flat]

* Question Regarding Unique Index on Table
@ 2010-09-23 17:18 Ozer, Pam <pozer@automotive.com>
  2010-09-23 18:33 ` Re: Question Regarding Unique Index on Table Kenneth Marshall <ktm@rice.edu>
  0 siblings, 1 reply; 2+ messages in thread

From: Ozer, Pam @ 2010-09-23 17:18 UTC (permalink / raw)
  To: 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 <mailto:pozer@automotive.com>  

tel. 949.705.3468

 

 

Source Interlink Media

1733 Alton Pkwy Suite 100, Irvine, CA 92606

www.simautomotive.com <http://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.

Attachments:

  [image/jpeg] image001.jpg (3.7K, ../../216FFB77CBFAEE4B8EE4DF0A939FF1D10182A9@mail-001.corp.automotive.com/3-image001.jpg)
  download | view image

  [image/jpeg] image002.jpg (346B, ../../216FFB77CBFAEE4B8EE4DF0A939FF1D10182A9@mail-001.corp.automotive.com/4-image002.jpg)
  download | view image

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Question Regarding Unique Index on Table
  2010-09-23 17:18 Question Regarding Unique Index on Table Ozer, Pam <pozer@automotive.com>
@ 2010-09-23 18:33 ` Kenneth Marshall <ktm@rice.edu>
  0 siblings, 0 replies; 2+ messages in thread

From: Kenneth Marshall @ 2010-09-23 18:33 UTC (permalink / raw)
  To: Ozer, Pam <pozer@automotive.com>; +Cc: pgsql-sql

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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2010-09-23 18:33 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-09-23 17:18 Question Regarding Unique Index on Table Ozer, Pam <pozer@automotive.com>
2010-09-23 18:33 ` Kenneth Marshall <ktm@rice.edu>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox