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

From Tom Lane
Subject Re: BUG #17008: pg_dump doesn't dump a sequence with bigint type
Date
Msg-id 1579763.1620930869@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #17008: pg_dump doesn't dump a sequence with bigint type  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Responses Re: BUG #17008: pg_dump doesn't dump a sequence with bigint type  (Jaime Acevedo <jacevedo@we-techs.com>)
List pgsql-bugs
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: Alvaro Herrera
Date:
Subject: Re: BUG #17008: pg_dump doesn't dump a sequence with bigint type
Next
From: Jaime Acevedo
Date:
Subject: Re: BUG #17008: pg_dump doesn't dump a sequence with bigint type