Received: from web802.mail.yahoo.com (web802.mail.yahoo.com [128.11.23.62]) by hub.org (8.10.1/8.10.1) with SMTP id e7U3ppC42299 for ; Tue, 29 Aug 2000 23:51:51 -0400 (EDT) Received: (qmail 11463 invoked by uid 60001); 30 Aug 2000 03:52:15 -0000 Message-ID: <20000830035215.11462.qmail@web802.mail.yahoo.com> Received: from [199.174.221.112] by web802.mail.yahoo.com; Tue, 29 Aug 2000 20:52:15 PDT Date: Tue, 29 Aug 2000 20:52:15 -0700 (PDT) From: Webb Sprague Subject: Re: Create Primary Key + Massive Copy's? To: Stephan Szabo Cc: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200008/337 This is my next approach--I got rid of all indexes and PK's, and then created an index with unique after everything is added. Wish me luck. W --- Stephan Szabo wrote: > > We don't currently support the SQL syntax for adding > a PK to a table. However, if you have the columns > as NOT NULL already, adding a unique index to the > columns in question has the same general effect. > > Stephan Szabo > sszabo@bigpanda.com > > On Tue, 29 Aug 2000, Webb Sprague wrote: > > > Apropos of my last question: > > > > Is there syntax to create a primary key after the > > table has been defined and populated? I think I > could > > speed things up quite a bit by not having any > indexes > > at all when I do my mass copies. > __________________________________________________ Do You Yahoo!? Yahoo! Mail - Free email you can access from anywhere! http://mail.yahoo.com/