Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] \copy (query) delimiter syntax error

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Michael Fuhr <mike(at)fuhr(dot)org>
Cc: pgsql-hackers(at)postgresql(dot)org, "Patches (PostgreSQL)" <pgsql-patches(at)postgresql(dot)org>
Subject: Re: [HACKERS] \copy (query) delimiter syntax error
Date: 2007-02-03 19:54:24
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackerspgsql-patches

Michael Fuhr wrote:
> On Sat, Feb 03, 2007 at 10:52:29AM -0600, Andrew Dunstan wrote:
>> I'd say fix psql. Not sure how far back we should backpatch it. It's
>> interesting that this has been there since 8.0 and is only now discovered.
> The problem is new in 8.2 because COPY (query) doesn't support USING
> DELIMITERS.  COPY tablename does, so it has worked all along.

oh, good point. OK, I have cut this quick patch that will continue to 
accept the legacy syntax in psql in non-inline-query cases, but will 
make psql unreservedly emit new style syntax for COPY to the backend.  
Does that seem reasonable, or is it too much of a change for the stable 



Attachment: copy.patch
Description: text/x-patch (3.9 KB)

In response to


pgsql-hackers by date

Next:From: Jan WieckDate: 2007-02-03 20:52:50
Subject: Re: Proposal: Commit timestamp
Previous:From: Matthias LuedtkeDate: 2007-02-03 19:02:36
Subject: Re: --enable-debug does not work with gcc

pgsql-patches by date

Next:From: Bruce MomjianDate: 2007-02-03 23:46:56
Subject: Re: date comparisons
Previous:From: Michael FuhrDate: 2007-02-03 17:12:07
Subject: Re: \copy (query) delimiter syntax error

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group