Skip site navigation (1) Skip section navigation (2)

Re: Can primary key be dropped and added back in?

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Jessica Richard <rjessil(at)yahoo(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Can primary key be dropped and added back in?
Date: 2007-07-17 18:49:20
Message-ID: 469D0F30.60002@commandprompt.com (view raw or flat)
Thread:
Lists: pgsql-admin
Jessica Richard wrote:
> I have a huge table to load (30+M rows).
> 
> Dropping indexes before loading will speed up my process, but I am not 
> sure about the primary key that was created with the table creation. Is 
> the Postgres primary key treated like an index? If yes, dropping the 
> primary key might help my loading as well.... I can drop the primary key by
> 
> alter table tbleName drop constraint pkname_pkey.. it dropped clean this 
> way.
> 
> But I haven't found the command to put the primary key back (all for 
> testing now)

alter table foo add primary key (baz);

Joshua D. Drake

> 
> Is there a command to add the primary key back after loading the data?
> 
> Thanks
> 
> ------------------------------------------------------------------------
> Moody friends. Drama queens. Your life? Nope! - their life, your story.
> Play Sims Stories at Yahoo! Games. 
> <http://us.rd.yahoo.com/evt=48224/*http://sims.yahoo.com/>


-- 

       === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
              http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/


In response to

pgsql-admin by date

Next:From: Igor NeymanDate: 2007-07-17 19:20:47
Subject: Re: Can primary key be dropped and added back in?
Previous:From: De Leeuw GuyDate: 2007-07-17 18:45:13
Subject: Re: cache problem (v2)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group