COPY .... WITH (FORMAT binary) causes syntax error at or near "binary"

From: Pavel Golub <pavel(at)microolap(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: COPY .... WITH (FORMAT binary) causes syntax error at or near "binary"
Date: 2011-07-05 14:52:06
Message-ID: 6510382810.20110705175206@gf.microolap.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

Hello.

System: PostgreSQL v9.0 Windows XP SP3
SQL: COPY "tablename" TO STDOUT WITH (FORMAT binary)
ERROR: syntax error at or near "binary"
LINE 1: ...OPY "tablename" TO STDOUT WITH (FORMAT binary)
^

********** Error **********

ERROR: syntax error at or near "binary"
SQL state: 42601
Character: 55

But if I use 'FORMAT text' or 'FORMAT csv' all is OK.

Suppose this happens because BINARY is not listed in
"unreserved_keyword" neither in "col_name_keyword parser" parser rules, but
listed in "type_func_name_keyword" instead.

--
With best wishes,
Pavel mailto:pavel(at)gf(dot)microolap(dot)com

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2011-07-05 15:06:42 Re: [HACKERS] COPY .... WITH (FORMAT binary) causes syntax error at or near "binary"
Previous Message Robert Haas 2011-07-05 13:07:47 Re: BUG #6083: psql script line numbers incorrectly count \copy data

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2011-07-05 15:03:44 Re: [COMMITTERS] pgsql: Move Trigger and TriggerDesc structs out of rel.h into a new rel
Previous Message Kevin Grittner 2011-07-05 14:51:51 Re: Small SSI issues