Re: initdb failure (was Re: [GENERAL] sequence's plpgsql) - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: initdb failure (was Re: [GENERAL] sequence's plpgsql)
Date
Msg-id 3F748371.1050903@dunslane.net
Whole thread Raw
In response to Re: initdb failure (was Re: [GENERAL] sequence's plpgsql)  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: initdb failure (was Re: [GENERAL] sequence's plpgsql)
List pgsql-hackers
Bruce Momjian wrote:

>I posted on that a few minutes ago.  Yea, we can drop it, but we risk
>eating carraige returns as data values.  I am not sure how consistently
>we output literal carriage returns in old dumps, nor how many apps
>produce on literal carriage returns in COPY. If we conditionally eat
>them, we run the risk of discarding some of their data without warning. 
>Perhaps we can throw a warning rather than an error, and adjust initdb
>to be consistent.
>
>  
>

Would the best longterm solution be to require escaping CR in a data 
value? (Yes I know this might cause backwards compatibility problems, at 
least for a while).

cheers

andrew



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: initdb failure (was Re: [GENERAL] sequence's plpgsql)
Next
From: Tom Lane
Date:
Subject: Re: initdb failure (was Re: [GENERAL] sequence's plpgsql)