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