From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Jaime Acevedo <jacevedo@we-techs.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17008: pg_dump doesn't dump a sequence with bigint type
Date: Thu, 13 May 2021 14:29:31 -0400
Message-ID: <20210513182931.GA20675@alvherre.pgsql> (raw)
In-Reply-To: <CACvFstpJ==dkYHeyydCoftoc0x-fx-wsdF0sRs=h5Y5-T1DO_Q@mail.gmail.com>
On 2021-May-13, Jaime Acevedo wrote:
> Sorry, I made a mistake at the moment to copy & paste the sequences.
>
> But this finally the problems was the filter to do dump, when I use
> --exclude-table option with pattern projects_historydata_* for some reason
> the sequences was excluded finally I used the pattern
> projects_historydata_[0-9]* to exclude only the tables that I want to
> exclude.
Ah, that makes sense.
> I don´t know if that behavior is right.
Hmm, I think --exclude-tables should exclude tables only, not sequences.
And it does behave like that for me, in a quick test with version 10.
What version of Postgres are you using?
--
Álvaro Herrera 39°49'30"S 73°17'W
"Estoy de acuerdo contigo en que la verdad absoluta no existe...
El problema es que la mentira sí existe y tu estás mintiendo" (G. Lama)
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: alvherre@alvh.no-ip.org, jacevedo@we-techs.com, tgl@sss.pgh.pa.us, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17008: pg_dump doesn't dump a sequence with bigint type
In-Reply-To: <20210513182931.GA20675@alvherre.pgsql>
* 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