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

[Michael P. <mic...@gm...>]

Thanks for this report.
It has already been fixed with this commit:
https://github.com/postgres-xc/postgres-xc/commit/8a95ba5f4146dae958f4520869bad6593a3bf254
You can expect the tarball with the fix included when 1.0.1 is out some
time next month.
Thanks,

On Wed, Aug 22, 2012 at 4:35 AM, Nick Maludy <nm...@gm...> wrote:

> 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:
> ---------------------------------------------------------------------*
>
>
>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> Postgres-xc-bugs mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-bugs
>
>


-- 
Michael Paquier
http://michael.otacoo.com