Re: Inheritance, CREATE TABLE LIKE, and partitioned tables

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: Inheritance, CREATE TABLE LIKE, and partitioned tables
Дата
Msg-id 87y7vjwrwl.fsf@stark.xeocode.com
обсуждение исходный текст
Ответ на Re: Inheritance, CREATE TABLE LIKE, and partitioned tables  (elein <elein@varlena.com>)
Список pgsql-hackers
elein <elein@varlena.com> writes:

> People will turn around and immediately as for create table like without us
> making the assumptions it wanted all of the extras that come with inheritance.
> COPY is a copy of the table, not additional functionality.  The added flexibility
> of adding only what is necessary makes more sense than going in to guess
> what was added and removing it later if it is not needed.
> 
> This does not preclude adding a copy table like (with extras) though if you must.

I'm not too sure what you're saying here. But just to be clear, the spec
specifies what CREATE TABLE LIKE does and does not copy. Any behaviour
different from the spec would have to be explicitly requested with an optional
clause.

-- 
greg



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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: "Truncated" tuples for tuple hash tables
Следующее
От: Tom Lane
Дата:
Сообщение: Re: "Truncated" tuples for tuple hash tables