[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-sql
Subject:    Re: [SQL] Question Regarding Unique Index on Table
From:       Kenneth Marshall <ktm () rice ! edu>
Date:       2010-09-23 18:33:02
Message-ID: 20100923183302.GB17736 () aart ! is ! rice ! edu
[Download RAW message or body]

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

-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
[prev in list] [next in list] [prev in thread] [next in thread]