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

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

From: Euler Taveira de Oliveira <euler(at)timbira(dot)com>
To: handling numeric literals with dots in psql copy command <filip(dot)rembialkowski(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4927: psql does "spoil" the query before sending it to server
Date: 2009-07-17 19:50:02
Message-ID: 4A60D5EA.5060308@timbira.com (view raw or flat)
Thread:
Lists: pgsql-bugs
handling numeric literals with dots in psql copy command escreveu:
> 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
> 
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/

Attachment: psql
Description: text/plain (671 bytes)

In response to

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2009-07-17 21:26:04
Subject: Re: BUG #4927: psql does "spoil" the query before sending it to server
Previous:From: Tom LaneDate: 2009-07-17 18:36:41
Subject: Re: BUG #4926: too few pathkeys for mergeclauses

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