Re: BUG #10701: pg_dumpall.exe adds 0x0d to table comments - Mailing list pgsql-bugs

From Bruce Momjian
Subject Re: BUG #10701: pg_dumpall.exe adds 0x0d to table comments
Date
Msg-id 20141011185620.GC21267@momjian.us
Whole thread Raw
In response to BUG #10701: pg_dumpall.exe adds 0x0d to table comments  (mundus13@yahoo.de)
List pgsql-bugs
On Thu, Jun 19, 2014 at 11:29:44AM +0000, mundus13@yahoo.de wrote:
> The following bug has been logged on the website:
>
> Bug reference:      10701
> Logged by:          Michael
> Email address:      mundus13@yahoo.de
> PostgreSQL version: 9.3.4
> Operating system:   Windows 7 64Bit
> Description:
>
> When pg_dumpall.exe exports a table which contains 0x0d 0x0a in the table
> comment
> an additional \x0d is added to the export file.
>
> Repro:
>
> CREATE TABLE public.test2 (
> ...
>
> COMMENT ON TABLE public.test2
> IS 'desc1
> desc2
> ';

I looked into this and I can't see why only COMMENT ON TABLE would be
affected.  Does it cause other problems?

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + Everyone has their own god. +

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: BUG #10680: LDAP bind password leaks to log on failed authentication
Next
From: Bruce Momjian
Date:
Subject: Re: BUG #11033: 'pg_dump -a' much slower than 'pg_dump'