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.
--- Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
> 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
> 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
> > speed things up quite a bit by not having any
> > at all when I do my mass copies.
Do You Yahoo!?
Yahoo! Mail - Free email you can access from anywhere!
pgsql-sql by date
|Next:||From: D'Arcy J.M. Cain||Date: 2000-08-30 11:42:48|
|Subject: Re: Create Primary Key?|
|Previous:||From: Stephan Szabo||Date: 2000-08-30 01:55:42|
|Subject: Re: Optimizing huge inserts/copy's|