Re: Create Primary Key?

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: Create Primary Key?
Дата
Msg-id Pine.BSF.4.10.10008291808340.57603-100000@megazone23.bigpanda.com
обсуждение исходный текст
Ответ на Create Primary Key?  (Webb Sprague <wsprague100@yahoo.com>)
Ответы Re: Create Primary Key?  (darcy@druid.net (D'Arcy J.M. Cain))
Список pgsql-sql
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.



В списке pgsql-sql по дате отправления:

Предыдущее
От: Webb Sprague
Дата:
Сообщение: Create Primary Key?
Следующее
От: Jie Liang
Дата:
Сообщение: Re: Optimizing huge inserts/copy's