| From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
|---|---|
| To: | Jaime Acevedo <jacevedo(at)we-techs(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: BUG #17008: pg_dump doesn't dump a sequence with bigint type |
| Date: | 2021-05-13 18:29:31 |
| Message-ID: | 20210513182931.GA20675@alvherre.pgsql |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2021-05-13 18:34:29 | Re: BUG #17008: pg_dump doesn't dump a sequence with bigint type |
| Previous Message | Alvaro Herrera | 2021-05-13 18:21:41 | Re: BUG #17008: pg_dump doesn't dump a sequence with bigint type |