Re: Clarification regarding CREATE TABLE LIKE and FOREIGN KEYS

2023-12-01 Thread David G. Johnston
On Fri, Dec 1, 2023 at 7:07 AM David Virebayre wrote: > "INCLUDING ALL" leads people to believe *everything* is copied. > > The fact that it doesn't seem counter intuitive, at least to me. > > Therefore, it doesn't seem absurd to me to warn people about what is not > copied. > > I wrote the origi

Re: Clarification regarding CREATE TABLE LIKE and FOREIGN KEYS

2023-12-01 Thread David Virebayre
Le mer. 29 nov. 2023 à 16:24, Euler Taveira a écrit : > 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

Re: Clarification regarding CREATE TABLE LIKE and FOREIGN KEYS

2023-11-29 Thread Euler Taveira
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*