Re: Retail DDL - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Retail DDL
Date
Msg-id 1857472.1753450511@sss.pgh.pa.us
Whole thread Raw
In response to Re: Retail DDL  (Álvaro Herrera <alvherre@kurilemu.de>)
Responses Re: Retail DDL
List pgsql-hackers
=?utf-8?Q?=C3=81lvaro?= Herrera <alvherre@kurilemu.de> writes:
> Reproducing a table might need multiple commands.  Do you intend to
> return a single string containing multiple semicolon-separated commands,
> or are you thinking in a RETURNS SETOF where each row contains a single
> command?

In the same vein: would we expect this command to also build the
table's indexes?  What about foreign key constraints, which might
well reference tables that don't exist yet?

Once you start crawling down this rabbit-hole, you soon realize
why pg_dump is as complicated as it is.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Bertrand Drouvot
Date:
Subject: Re: Add os_page_num to pg_buffercache
Next
From: Aidar Imamov
Date:
Subject: Re: HASH_FIXED_SIZE flag gets lost when attaching to existing hash table