pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feed From: Bruce Momjian <bruce@momjian.us>
To: David G. Johnston <david.g.johnston@gmail.com>
Cc: Lior Dahan <liord@qmasters.co>
Cc: Daniel Gustafsson <daniel@yesql.se>
Cc: pgsql-bugs@postgresql.org <pgsql-bugs@postgresql.org>
Cc: Jonathan Tauman <JonathanT@qmasters.co>
Subject: Re: Issues with pg_dump command
Date: Wed, 18 Nov 2020 09:55:05 -0500
Message-ID: <20201118145505.GC13825@momjian.us> (raw )
In-Reply-To: <CAKFQuwadsLCQq1Ezor2wz4Cr2=Ogv8GNFJoFYof5dPY1TXD0JA@mail.gmail.com >
References: <DB8P192MB07585B86C91011572EA8924BABE10@DB8P192MB0758.EURP192.PROD.OUTLOOK.COM >
<F4554981-1C79-48DA-996F-0D4943061A71@yesql.se >
<AM8P192MB11081685C9DC1A673979021CBAE10@AM8P192MB1108.EURP192.PROD.OUTLOOK.COM >
<20201118141622.GA13825@momjian.us >
<AM8P192MB110866644C25CE4FFB2278A1BAE10@AM8P192MB1108.EURP192.PROD.OUTLOOK.COM >
<CAKFQuwadsLCQq1Ezor2wz4Cr2=Ogv8GNFJoFYof5dPY1TXD0JA@mail.gmail.com >
On Wed, Nov 18, 2020 at 07:52:31AM -0700, David G. Johnston wrote:
> On Wed, Nov 18, 2020 at 7:44 AM Lior Dahan <liord@qmasters.co> wrote:
>
> Is there a way we can tell which tables are under this parent one? Perhaps
> we can dump them instead.
>
>
> The convention here is to inline or bottom-post.
>
> If you don't use declarative partitioning then the specifics of the
> partitioning are buried inside the custom trigger functions that you wrote. If
> you dump triggers, they will show in the pg_dump output, otherwise you will
> have to investigate using other means.
He is on PG 9.6.15, which doesn't support declarative partitioning, so
it must be trigger-based.
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EnterpriseDB https://enterprisedb.com
The usefulness of a cup is in its emptiness, Bruce Lee
view thread (9+ messages)
Message-ID: <20201118145505.GC13825@momjian.us>
Permalink: ../20201118145505.GC13825@momjian.us/
Also on: postgresql.org/message-id/20201118145505.GC13825@momjian.us
copy link · copy postgr.es
reply Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: bruce@momjian.us, david.g.johnston@gmail.com, liord@qmasters.co, daniel@yesql.se, JonathanT@qmasters.co
Subject: Re: Issues with pg_dump command
In-Reply-To: <20201118145505.GC13825@momjian.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox