RE: Issues with pg_dump command

Is there a way we can tell which tables are under this parent one? Perhaps we can dump them instead.

-----Original Message-----
From: Bruce Momjian <bruce(at)momjian(dot)us>
Sent: Wednesday, November 18, 2020 4:16 PM
To: Lior Dahan <liord(at)qmasters(dot)co>
Cc: Daniel Gustafsson <daniel(at)yesql(dot)se>; pgsql-bugs(at)postgresql(dot)org; Jonathan Tauman <JonathanT(at)qmasters(dot)co>
Subject: Re: Issues with pg_dump command

On Wed, Nov 18, 2020 at 01:57:46PM +0000, Lior Dahan wrote:
> We are calling pg_dump for a 9.6.15 PostgreSQL installation (on QRadar).
>
> Here is the call to the command:
> pg_dump -U qradar -d qradar -a --disable-triggers -t ariel_property
>
> The dump output looks like this:

Based on the triggers, I wonder if ariel_property is the parent of a partitioned table, and there is nothing in the parent table.

--
Bruce Momjian <bruce(at)momjian(dot)us> https://momjian.us
EnterpriseDB https://enterprisedb.com

The usefulness of a cup is in its emptiness, Bruce Lee