Re: BUG #17008: pg_dump doesn't dump a sequence with bigint type - Mailing list pgsql-bugs

From Jaime Acevedo
Subject Re: BUG #17008: pg_dump doesn't dump a sequence with bigint type
Date
Msg-id CACvFstrypPmBNxoZTp0D3CXAp_sk9iR3cq+KYPmddPyEhr_mNg@mail.gmail.com
Whole thread Raw
In response to Re: BUG #17008: pg_dump doesn't dump a sequence with bigint type  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Ok, thanks. 

El jue, 13 may 2021 a las 14:34, Tom Lane (<tgl@sss.pgh.pa.us>) escribió:
Alvaro Herrera <alvherre@alvh.no-ip.org> writes:
> 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.

Probably your original thought is right: the sequence isn't properly owned
by the table column, so it doesn't get dumped in a selective dump.

                        regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #17008: pg_dump doesn't dump a sequence with bigint type
Next
From: David Rowley
Date:
Subject: Re: BUG #16968: Planner does not recognize optimization