From: | Michael Paquier <michael(at)paquier(dot)xyz> |
---|---|
To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
Subject: | pgsql: Avoid retrieval of CHECK constraints and DEFAULT exprs in data-o |
Date: | 2020-09-16 07:30:14 |
Message-ID: | E1kIRtO-0002TD-Bh@gemulon.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
Avoid retrieval of CHECK constraints and DEFAULT exprs in data-only dump
Those extra queries are not necessary when doing a data-only dump. With
this change, this means that the dependencies between CHECK/DEFAULT and
the parent table are not tracked anymore for a data-only dump. However,
these dependencies are only used for the schema generation and we have
never guaranteed that a dump can be reloaded if a CHECK constraint uses
a custom function whose behavior changes when loading the data, like
when using cross-table references in the CHECK function.
Author: Julien Rouhaud
Reviewed-by: Daniel Gustafsson, Michael Paquier
Discussion: https://postgr.es/m/20200712054850.GA92357@nol
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/5423853feebd30772b7ff9b306885dcb02b79e76
Modified Files
--------------
src/bin/pg_dump/pg_dump.c | 10 ++++++----
1 file changed, 6 insertions(+), 4 deletions(-)
From | Date | Subject | |
---|---|---|---|
Next Message | Fujii Masao | 2020-09-16 09:48:41 | pgsql: Add leader_pid field into the example of file_fdw for csvlog. |
Previous Message | Jeff Davis | 2020-09-16 04:51:26 | pgsql: Change LogicalTapeSetBlocks() to use nBlocksWritten. |