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

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 (view raw or flat)
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

pgsql-bugs by date

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

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