Re: Clarification regarding CREATE TABLE LIKE and FOREIGN KEYS

From: "Euler Taveira" <euler(at)eulerto(dot)com>
To: david(at)robbez(dot)com, pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: Clarification regarding CREATE TABLE LIKE and FOREIGN KEYS
Date: 2023-11-29 15:24:23
Message-ID: b1e8e241-d2d1-4a53-8ba8-2f72b920b8c6@app.fastmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

On Mon, Nov 27, 2023, at 12:05 PM, PG Doc comments form wrote:
> It is not clear to me that foreign keys are copied or not when duplicating a
> table using CREATE TABLE ... LIKE ... INCLUDING ALL. I had to actually test
> to check what it does.
>

It is impractical to add what a feature *does not* provide in general. The
probability that that information will be obsolete (due to new features) is
high. If the information is missing that's because it is not supported. (Of
course, it can be an omission and, in this case, we need to fix it.)

--
Euler Taveira
EDB https://www.enterprisedb.com/

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Tom Lane 2023-11-29 16:26:46 Re: "name" vs "alias" in datatype table
Previous Message Eric Hanson 2023-11-29 15:16:57 Re: "name" vs "alias" in datatype table