[Postgres-xc-bugs] COPY command rejects CamelCase table names

[Nick M. <nm...@gm...>]

Your name               : Nick Maludy
Your email address      : nm...@gm...


System Configuration:
---------------------
  Architecture : Intel x86_64

  Operating System      :  Scientific Linux 6 Kernel 2.6.32.59

  Postgres-XC version :  psql (PGXC 1.0.0, based on PG 9.1.4)

  Compiler used            : gcc (GCC) 4.6.1


Please enter a FULL description of your problem:
------------------------------------------------
I am receiving an error when trying to COPY from a table whose name is
in CamelCase and is required to be quoted.

I am able to successfully COPY this table if i use a COPY with SELECT.



Please describe a way to repeat the problem.   Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------

$ psql test_db

test_db=# CREATE TABLE "CamelCase" (i integer);

CREATE TABLE

test_db=# INSERT INTO "CamelCase" VALUES (3);

INSERT 0 1

test_db=# COPY "CamelCase" TO STDOUT;

ERROR:  relation "camelcase" does not exist

test_db=# COPY (SELECT * FROM "CamelCase") TO STDOUT;

3


If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------*