postgres-xc-developers

[Postgres-xc-developers] Issues with schema qualified tables and \COPY

[Nikhil S. <ni...@st...>]

Hi,

Looks like \COPY does not handle schema qualified tables properly. The
COPY command that is sent to the remote nodes forgets to schema
qualify the table:

create schema foo;
create table foo.bar(x int);
\copy foo.bar (x) FROM 'file.txt' with csv;

The above fails. The fix is to schema-qualify the table before sending
it on the wire. We need to be careful about temp tables though. PFA,
patch against HEAD for the same.

Regards,
Nikhils
-- 
StormDB - http://www.stormdb.com
The Database Cloud

Re: [Postgres-xc-developers] Issues with schema qualified tables and \COPY

[Koichi S. <koi...@gm...>]

Thanks Nikhil.   I found the similar problem in ALTER TABLE regression.
Hope this fixes the regression too.

----------
Koichi Suzuki


2013/4/3 Nikhil Sontakke <ni...@st...>

> Hi,
>
> Looks like \COPY does not handle schema qualified tables properly. The
> COPY command that is sent to the remote nodes forgets to schema
> qualify the table:
>
> create schema foo;
> create table foo.bar(x int);
> \copy foo.bar (x) FROM 'file.txt' with csv;
>
> The above fails. The fix is to schema-qualify the table before sending
> it on the wire. We need to be careful about temp tables though. PFA,
> patch against HEAD for the same.
>
> Regards,
> Nikhils
> --
> StormDB - http://www.stormdb.com
> The Database Cloud
>
>
> ------------------------------------------------------------------------------
> Minimize network downtime and maximize team effectiveness.
> Reduce network management and security costs.Learn how to hire
> the most talented Cisco Certified professionals. Visit the
> Employer Resources Portal
> http://www.cisco.com/web/learning/employer_resources/index.html
> _______________________________________________
> Postgres-xc-developers mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers
>
>