Re: BUG #5959: pg_restore --use-list does not always work with a pg_restore generated TOC file - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #5959: pg_restore --use-list does not always work with a pg_restore generated TOC file
Date
Msg-id 14343.1302191065@sss.pgh.pa.us
Whole thread Raw
In response to BUG #5959: pg_restore --use-list does not always work with a pg_restore generated TOC file  ("Per-Olov Esgard" <Per-Olov.Esgard@micronic-mydata.com>)
List pgsql-bugs
I wrote:
> Per-Olov Esgard <Per-Olov.Esgard@micronic-mydata.com> writes:
>> The third extracted buffer is not ok but interpreted as ok with id 10:
>> 10."boolean", mydbcomndata_10."boolean", mydbcomndata_10."boolean",
>> mydbcomndata_10."boolean", mydbcomndata_10."boolean", character varying,
>> mydbcomndata_10."integer", mydbcomndata_10.componentname,
>> mydbcomndata_10."integer", mydbcomndata_10."integer",
>> mydbcomndata_10."integer", mydbcomndata_10.angle,
>> mydbcomndata_10."boolean", mydbcomndata_10."boolean",
>> mydbcomndata_10."boolean", mydbcomndata_10."boolean",
>> mydbcomndata_10."boolean", mydbcomndata_10."boolean",
>> mydbcomndata_10."boolean") postgres

>> So as you can see, the last part of  my schema name consists of a number
>> that is interpreted as an id.

> Ah, I see.  So what we probably need to do for a real fix is to teach
> that code to distinguish continuation lines from normal ones.

Fix committed --- thanks for the report!

            regards, tom lane

pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Failed assert ((data - start) == data_size) in heaptuple.c
Next
From: "Halli, Savita"
Date:
Subject: Re: BUG #5967: Db maintainace