Re: BUG #5411: \copy do not work with dot "." in query

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Vitalii Tymchyshyn" <tivv00(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5411: \copy do not work with dot "." in query
Date: 2010-04-10 04:56:29
Message-ID: 22013.1270875389@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Vitalii Tymchyshyn" <tivv00(at)gmail(dot)com> writes:
> dict=> \copy (select 1.0) to test.tst
> ERROR: syntax error at or near "."
> LINE 1: COPY ( select 1 . 0 ) TO STDOUT
> ^

This case works as expected in CVS HEAD, apparently because of this fix:
http://archives.postgresql.org/pgsql-committers/2009-09/msg00184.php

I doubt we'd risk backpatching the whole change, but maybe it would
be sensible to backpatch just the changes in the COPY (SELECT) part
(lines 119-137 in HEAD). Not sure that it's worth taking any risk
for, though, given the lack of previous complaints.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Craig Ringer 2010-04-10 11:13:21 Re: bugs that have not been replied-to on list
Previous Message Kevin Grittner 2010-04-09 18:39:09 Re: pgadmin supports on SLES10.3