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

 · 

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