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

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

From: "handling numeric literals with dots in psql \copy command" <filip(dot)rembialkowski(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4927: psql does "spoil" the query before sending it to server
Date: 2009-07-17 10:31:52
Message-ID: 200907171031.n6HAVqw3084583@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      4927
Logged by:          handling numeric literals with dots in psql \copy
command
Email address:      filip(dot)rembialkowski(at)gmail(dot)com
PostgreSQL version: 8.4.0
Operating system:   Linux
Description:        psql does "spoil" the query before sending it to server
Details: 

8.4.0:

filip(at)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

Responses

pgsql-bugs by date

Next:From: Peter EisentrautDate: 2009-07-17 10:36:44
Subject: Re: Huge speed penalty using <>TRUE instead of =FALSE
Previous:From: Mikael KrantzDate: 2009-07-17 09:45:47
Subject: Re: Huge speed penalty using <>TRUE instead of =FALSE

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