CREATE TABLE LIKE, regarding constraints

Поиск
Список
Период
Сортировка
От
Тема CREATE TABLE LIKE, regarding constraints
Дата
Msg-id F3CBFBA88397EA498B22A05FFA9EC49D60A4123A@MX22A.corp.emc.com
обсуждение исходный текст
Ответы Re: CREATE TABLE LIKE, regarding constraints  (Magnus Hagander <magnus@hagander.net>)
Список pgsql-docs
www.postgresql.org/docs/9.0/static/sql-createtable.html
== == == == ==
LIKE parent_table [ like_option ... ]
. . .
Not-null constraints are always copied to the new table.
CHECK constraints will only be copied if INCLUDING CONSTRAINTS is specified; other types of constraints will never be
copied.
. . .
== == == == ==

But I do see PK and UNIQUE constraints
  CONSTRAINT blah_pkey PRIMARY KEY (id),
  CONSTRAINT blah_host_id_key UNIQUE (host_id)
in the def of the new table.


Also, why is there no discussion of what "EXCLUDING CONSTRAINTS" will result in ?

Thanks,
-dvs-



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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: small mvcc.sqml improvents
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: CREATE TABLE LIKE, regarding constraints