Re: create table like: ACCESS METHOD

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: create table like: ACCESS METHOD
Дата
Msg-id YVbAXQc9oaIYfkN1@paquier.xyz
обсуждение исходный текст
Ответ на Re: create table like: ACCESS METHOD  (Peter Eisentraut <peter.eisentraut@enterprisedb.com>)
Список pgsql-hackers
On Thu, Sep 09, 2021 at 02:30:51PM +0200, Peter Eisentraut wrote:
> Hmm.  The problem is that the LIKE clause is really a macro that expands to
> the column definitions of the other table.  So there is, so far, no such as
> thing as two LIKE clauses contradicting.  Whereas the access method is a
> table property.  So I don't think this syntax is the right approach for this
> feature.
>
> You might think about something like
>
> CREATE TABLE t2 (...) USING (LIKE t1);
>
> At least in terms of how the syntax should be structured.

Good point.  I have marked the patch as RwF.
--
Michael

Вложения

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

Предыдущее
От: Kyotaro Horiguchi
Дата:
Сообщение: Re: Allow escape in application_name
Следующее
От: Greg Nancarrow
Дата:
Сообщение: Re: Logical replication keepalive flood