Re: create table like: ACCESS METHOD

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: create table like: ACCESS METHOD
Дата
Msg-id YSxlWNYZbwYIvpJ8@paquier.xyz
обсуждение исходный текст
Ответ на Re: create table like: ACCESS METHOD  (Vik Fearing <vik@postgresfriends.org>)
Список pgsql-hackers
On Fri, Aug 27, 2021 at 12:37:59PM +0200, Vik Fearing wrote:
> It seems like this should error to me:
>
> CREATE ACCESS METHOD heapdup TYPE TABLE HANDLER heap_tableam_handler;
> CREATE TABLE likeam1() USING heap;
> CREATE TABLE likeam2() USING heapdup;
> CREATE TABLE likeamlike(
>     LIKE likeam1 INCLUDING ACCESS METHOD,
>     LIKE likeam2 INCLUDING ACCESS METHOD
> );
>
> At the very least, the documentation should say that the last one wins.

An error may be annoying once you do an INCLUDING ALL with more than
one relation, no?  I'd be fine with just documenting that the last one
wins.
--
Michael

Вложения

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

Предыдущее
От: Corey Huinker
Дата:
Сообщение: Re: simplifying foreign key/RI checks
Следующее
От: Tatsuo Ishii
Дата:
Сообщение: Re: Using COPY FREEZE in pgbench