Re: Proposal to CREATE FOREIGN TABLE LIKE - Mailing list pgsql-hackers

From Álvaro Herrera
Subject Re: Proposal to CREATE FOREIGN TABLE LIKE
Date
Msg-id 202502061029.s5sdtrnpfm7u@alvherre.pgsql
Whole thread Raw
In response to Proposal to CREATE FOREIGN TABLE LIKE  (Zhang Mingli <zmlpostgres@gmail.com>)
Responses Re: Proposal to CREATE FOREIGN TABLE LIKE
List pgsql-hackers
On 2025-Feb-06, Zhang Mingli wrote:

> Added support for CREATE FOREIGN TABLE LIKE to enable the creation of
> foreign tables based on the column definitions, constraints of
> existing source tables.
> This feature mirrors the behavior of CREATE TABLE LIKE, but ignores
> inapplicable options such as INCLUDING INDEXES and INCLUDING
> COMPRESSION for foreign tables.

I think it'd be better to throw errors if they are given -- but
INCLUDING ALL should be made to work in a different way than today so
that it doesn't raise errors uselessly.  Right now it works by setting
all the bits in the value, um.

-- 
Álvaro Herrera         PostgreSQL Developer  —  https://www.EnterpriseDB.com/



pgsql-hackers by date:

Previous
From: Bertrand Drouvot
Date:
Subject: Re: per backend WAL statistics
Next
From: Álvaro Herrera
Date:
Subject: Re: Proposal to CREATE FOREIGN TABLE LIKE