Re: [BUGS] BUG #2221: Bad delimiters allowed in COPY ...

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, David Fetter <david(at)fetter(dot)org>, Andrew Dunstan <andrew(at)dunslane(dot)net>, neilc(at)samurai(dot)com, PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: [BUGS] BUG #2221: Bad delimiters allowed in COPY ...
Date: 2007-02-05 22:40:54
Message-ID: 200702052240.l15MesV09047@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-patches

Tom Lane wrote:
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> > Attached is a patch that errors for \r and \n in delimiter and
> > null.
>
> I am not convinced that this is a bug. Can you prove that there is no
> use-case for asking COPY to emit data in this style? Sure, COPY itself
> couldn't read it, but people sometimes feed COPY output to other
> programs...

FYI, Tom, old email from Feb 1, 2006, from your server:

Received: from sss.pgh.pa.us (root(at)sss(dot)pgh(dot)pa(dot)us [66.207.139.130])
by momjian.us (8.11.6/8.11.6) with ESMTP id l14HX7l21306
for <pgman(at)candle(dot)pha(dot)pa(dot)us>; Sun, 4 Feb 2007 12:33:08 -0500 (EST)
Received: from sss2.sss.pgh.pa.us (tgl(at)localhost [127.0.0.1])
by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id l14HWWoj020066;
Sun, 4 Feb 2007 12:32:32 -0500 (EST)
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
cc: David Fetter <david(at)fetter(dot)org>, Andrew Dunstan <andrew(at)dunslane(dot)net>,
neilc(at)samurai(dot)com, PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: [PATCHES] [BUGS] BUG #2221: Bad delimiters allowed in COPY ...
In-Reply-To: <200602011410(dot)k11EApH14839(at)candle(dot)pha(dot)pa(dot)us>
References: <200602011410(dot)k11EApH14839(at)candle(dot)pha(dot)pa(dot)us>
Comments: In-reply-to Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
message dated "Wed, 01 Feb 2006 09:10:51 -0500"
----------------

--
Bruce Momjian bruce(at)momjian(dot)us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2007-02-05 22:44:38 Re: [BUGS] BUG #2221: Bad delimiters allowed in COPY ...
Previous Message Rich Teer 2007-02-05 19:16:35 BUG #2969: Inaccuracies in Solaris FAQ

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2007-02-05 22:44:38 Re: [BUGS] BUG #2221: Bad delimiters allowed in COPY ...
Previous Message Tom Lane 2007-02-05 21:40:41 Re: [pgsql-patches] Phantom Command IDs, updated patch