Re: Sequences not created, bug in pg_dump?

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: "Leonardo M(dot) Ramé" <l(dot)rame(at)griensu(dot)com>, PostgreSql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Sequences not created, bug in pg_dump?
Date: 2015-03-19 16:09:23
Message-ID: 550AF4B3.408@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Leonardo M. Ramé 2015-03-19 17:02:04 Re: Sequences not created, bug in pg_dump?
Previous Message Leonardo M. Ramé 2015-03-19 15:43:09 Sequences not created, bug in pg_dump?