Re: initdb failure (was Re: [GENERAL] sequence's plpgsql)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>, Tim McAuley <mcauleyt(at)tcd(dot)ie>
Subject: Re: initdb failure (was Re: [GENERAL] sequence's plpgsql)
Date: 2003-09-26 22:02:12
Message-ID: 27961.1064613732@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers pgsql-jdbc

I said:
> The question isn't so much "who has CRs in their data" as "who is trying
> to import data files in which CRs aren't correctly represented as \r" ?
> Not anyone upgrading from a recent PG release ... though 7.1 or before
> would have an issue.

Actually, checking the CVS logs shows that 7.2.1 was the first release
that would emit a data CR or LF as \r or \n rather than literally. If
Scott is dumping from an original 7.2 installation rather than a dot-
release, that would explain his report.

I talked to Bruce about this on the phone, and we now both feel that
that change was too recent to assume that people won't be trying to load
dumps containing bare CRs into 7.4. Accordingly, it seems that we do
need to throw an error or at least a warning for mixed newlines.
Eventually we can get rid of that behavior and just treat all newline
sequences alike, but I think we can't do it until 7.2.0 is in the
"ancient history" category.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2003-09-26 22:09:17 Re: initdb failure (was Re: [GENERAL] sequence's plpgsql)
Previous Message Peter Eisentraut 2003-09-26 22:00:11 Re: initdb failure (was Re: [GENERAL] sequence's plpgsql)

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-09-26 22:08:12 Re: pgsql-server/src/backend catalog/index.c comma ...
Previous Message Peter Eisentraut 2003-09-26 22:00:11 Re: initdb failure (was Re: [GENERAL] sequence's plpgsql)

Browse pgsql-jdbc by date

  From Date Subject
Next Message Peter Eisentraut 2003-09-26 22:09:17 Re: initdb failure (was Re: [GENERAL] sequence's plpgsql)
Previous Message Peter Eisentraut 2003-09-26 22:00:11 Re: initdb failure (was Re: [GENERAL] sequence's plpgsql)