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

From Leonardo M. Ramé
Subject Re: Sequences not created, bug in pg_dump?
Date
Msg-id 550B010C.4080504@griensu.com
Whole thread Raw
In response to Re: Sequences not created, bug in pg_dump?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Sequences not created, bug in pg_dump?  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
El 19/03/15 a las 13:09, Adrian Klaver escibió:
> 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.
>

Yes that's the problem. The dump is performed using 9.3.5 on windows.


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Sequences not created, bug in pg_dump?
Next
From: Adrian Klaver
Date:
Subject: Re: Sequences not created, bug in pg_dump?