Re: BUG #17008: pg_dump doesn't dump a sequence with bigint type

From: Jaime Acevedo <jacevedo(at)we-techs(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, 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:52:14
Message-ID: CACvFstrypPmBNxoZTp0D3CXAp_sk9iR3cq+KYPmddPyEhr_mNg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Ok, thanks.

El jue, 13 may 2021 a las 14:34, Tom Lane (<tgl(at)sss(dot)pgh(dot)pa(dot)us>) escribió:

> Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)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
>

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message David Rowley 2021-05-13 23:52:33 Re: BUG #16968: Planner does not recognize optimization
Previous Message Tom Lane 2021-05-13 18:34:29 Re: BUG #17008: pg_dump doesn't dump a sequence with bigint type