Re: Sequences not created, bug in pg_dump? - Mailing list pgsql-general

On 03/19/2015 08:43 AM, "Leonardo M. Ramé" wrote:
>
> Hi, I'm creating a database dump excluding one table and found only the
> sequences created implicitly (using serial type) are created when I
> restore the dump.
>
> The command I use is: pg_dump -T table_to_be_excluded mydb
>
> I understand all related objects to the table to be excluded are not
> dumpled, but why I don't get any CREATE SEQUENCE command in my dump?.
>

What version of Postgres?

If I follow you have CREATEd sequence(s) using CREATE SEQUENCE and they
do not show up in the dump file?

It works for me here on 9.3.


--
Adrian Klaver
adrian.klaver@aklaver.com