Re: Undocumented feature costs a lot of performance in COPY IN - Mailing list pgsql-hackers

From Doug McNaught
Subject Re: Undocumented feature costs a lot of performance in COPY IN
Date
Msg-id m3elmad9gw.fsf@belphigor.mcnaught.org
Whole thread Raw
In response to Undocumented feature costs a lot of performance in COPY IN  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Undocumented feature costs a lot of performance in COPY  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Tom Lane <tgl@sss.pgh.pa.us> writes:

> and indeed, only the first character is used by COPY OUT.  But COPY IN
> is presently coded so that if multiple characters are mentioned in
> USING DELIMITERS, any one of them will be taken as a field delimiter.
> 
> I would like to change the code to just "if (c == delim[0])",
> which should buy back most of that 20% and make the behavior match the
> documentation.  Question for the list: is this a bad change?  Is anyone
> out there actually using this undocumented behavior?

Not I.

As an utter nitpick, the syntax should IMHO be USING DELIMITER (no S)
if there is only one possible delimiter character.  But that *would*
break lots of apps so I don't advocate it.  ;)

-Doug
-- 
Let us cross over the river, and rest under the shade of the trees.  --T. J. Jackson, 1863


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Release info updated
Next
From: Bill Studenmund
Date:
Subject: Re: Undocumented feature costs a lot of performance in