BUG #4927: psql does "spoil" the query before sending it to server

handling numeric literals with dots in psql copy command escreveu:

filip@filip=# \copy ( select 1.23::numeric as num ) to 'out.csv' with csv
header
ERROR: syntax error at or near "."
LINE 1: COPY ( select 1 . 23::numeric as num ) TO STDOUT CSV HEADER
^
\copy: ERROR: syntax error at or near "."
LINE 1: COPY ( select 1 . 23::numeric as num ) TO STDOUT CSV HEADER
^

query inside parentheses is OK.

same bug reproduced in 8.3.7

Thanks for your report.

Why are we analysing the query there? One possible fix is to remove the '.' as
delimiter in strtokx(). The trivial patch is attached.

--
Euler Taveira de Oliveira
http://www.timbira.com/

Euler Taveira de Oliveira <euler@timbira.com> writes:

Why are we analysing the query there? One possible fix is to remove the '.' as
delimiter in strtokx(). The trivial patch is attached.

Surely that would break a lot of other cases.

regards, tom lane

Tom Lane escreveu:

Euler Taveira de Oliveira <euler@timbira.com> writes:

Why are we analysing the query there? One possible fix is to remove the '.' as
delimiter in strtokx(). The trivial patch is attached.

Surely that would break a lot of other cases.

Why? Even if it can't catch all cases when we remove the '.', the query will
be parsed (again) by PostgreSQL.

--
Euler Taveira de Oliveira
http://www.timbira.com/