Menu
▾
▴
Re: [Postgres-xc-bugs] Copy Command
|
From: Abbas B. <abb...@en...> - 2013-09-19 09:09:05
|
On Thu, Sep 19, 2013 at 3:17 AM, West, William <ww...@uc...> wrote: > All, > > I am attempting to use the copy command (as I previously did > successfully in Postgres) to copy data from a file on the file system. When > I try to upload data to the XC instance I get a 'relation does not exist' > error. However if I check the metadata table, called tables, it is in there: > > postgres=# select * from information_schema.tables where table_type = > 'BASE TABLE'; > table_catalog | table_schema | table_name | table_type > | self_referencing_column_name | reference_generation | > user_defined_type_catalog | > user_defined_type_schema | user_defined_type_name | is_insertable_into | > is_typed | commit_action > > ---------------+--------------------+-------------------------+------------+------------------------------+----------------------+---------------------------+ > > --------------------------+------------------------+--------------------+----------+--------------- > postgres | staging | mutect | BASE > TABLE | | | > | > | | YES | > NO | > postgres | staging | vcf | BASE TABLE > | | | > | > | | YES | > NO | > postgres | information_schema | sql_features | BASE TABLE > | | | > | > | | YES | > NO | > postgres | gene | vcf | BASE TABLE > | | | > | > | | YES | > NO | > postgres | staging | source_downloads | BASE TABLE > | | | > | > | | YES | > NO | > postgres | pg_catalog | pg_cast | BASE TABLE > | | | > | > | | YES | > NO | > postgres | pg_catalog | pg_am | BASE TABLE > | | | > | > | | YES | > NO | > postgres | pg_catalog | pg_attrdef | BASE TABLE > | | | > | > | | YES | > NO | > postgres | public | products2 | BASE TABLE > | | | > | > | | YES | > NO | > postgres | information_schema | sql_sizing_profiles | BASE TABLE > | | | > | > | | YES | > NO | > postgres | information_schema | sql_sizing | BASE TABLE > | | | > | > | | YES | > NO | > postgres | information_schema | sql_parts | BASE TABLE > | | | > | > | | YES | > NO | > postgres | information_schema | sql_packages | BASE TABLE > | | | > | > | | YES | > NO | > postgres | information_schema | sql_languages | BASE TABLE > | | | > | > | | YES | > NO | > postgres | information_schema | sql_implementation_info | BASE TABLE > | | | > | > | | YES | > NO | > postgres | public | products | BASE TABLE > | | | > | > | | YES | > NO | > postgres | pg_catalog | pg_collation | BASE TABLE > | | | > | > | | YES | > NO | > postgres | pg_catalog | pg_seclabel | BASE TABLE > | | | > | > | | YES | > NO | > postgres | pg_catalog | pg_default_acl | BASE TABLE > | | | > | > | | YES | > NO | > postgres | pg_catalog | pg_foreign_table | BASE TABLE > | | | > | > | | YES | > NO | > postgres | pg_catalog | pgxc_group | BASE TABLE > | | | > | > | | YES | > NO | > postgres | pg_catalog | pgxc_node | BASE TABLE > | | | > | > | | YES | > NO | > postgres | pg_catalog | pgxc_class | BASE TABLE > | | | > | > | | YES | > NO | > postgres | pg_catalog | pg_foreign_server | BASE TABLE > | | | > | > | | YES | > NO | > postgres | pg_catalog | pg_foreign_data_wrapper | BASE TABLE > | | | > | > | | YES | > NO | > postgres | pg_catalog | pg_extension | BASE TABLE > | | | > | > | | YES | > NO | > postgres | pg_catalog | pg_ts_template | BASE TABLE > | | | > | > | | YES | > NO | > postgres=# \copy staging.mutect from '/tmp/20.mutect.call_stats.out'; > ERROR: relation "mutect" does not exist > > Is this a known bug (version 1.0.3) or > I tried the use case on current master and could not reproduce the issue, Is it possible for you to upgrade to the latest release? > is there a different command for Copy in XC? > No, copy is supposed to work the same way it works on postgres. > > If it is a bug is there any work around for bulk loading data? > > > Thanks, > > Bill West > > > > ------------------------------------------------------------------------------ > LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99! > 1,500+ hours of tutorials including VisualStudio 2012, Windows 8, > SharePoint > 2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack > includes > Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/20/13. > http://pubads.g.doubleclick.net/gampad/clk?id=58041151&iu=/4140/ostg.clktrk > _______________________________________________ > Postgres-xc-bugs mailing list > Pos...@li... > https://lists.sourceforge.net/lists/listinfo/postgres-xc-bugs > > -- -- *Abbas* Architect Ph: 92.334.5100153 Skype ID: gabbasb www.enterprisedb.co <http://www.enterprisedb.com/>m<http://www.enterprisedb.com/> * Follow us on Twitter* @EnterpriseDB Visit EnterpriseDB for tutorials, webinars, whitepapers<http://www.enterprisedb.com/resources-community>and more<http://www.enterprisedb.com/resources-community> On Thu, Sep 19, 2013 at 3:17 AM, West, William <ww...@uc...> wrote: > All, > > I am attempting to use the copy command (as I previously did > successfully in Postgres) to copy data from a file on the file system. When > I try to upload data to the XC instance I get a 'relation does not exist' > error. However if I check the metadata table, called tables, it is in there: > > postgres=# select * from information_schema.tables where table_type = > 'BASE TABLE'; > table_catalog | table_schema | table_name | table_type > | self_referencing_column_name | reference_generation | > user_defined_type_catalog | > user_defined_type_schema | user_defined_type_name | is_insertable_into | > is_typed | commit_action > > ---------------+--------------------+-------------------------+------------+------------------------------+----------------------+---------------------------+ > > --------------------------+------------------------+--------------------+----------+--------------- > postgres | staging | mutect | BASE > TABLE | | | > | > | | YES | > NO | > postgres | staging | vcf | BASE TABLE > | | | > | > | | YES | > NO | > postgres | information_schema | sql_features | BASE TABLE > | | | > | > | | YES | > NO | > postgres | gene | vcf | BASE TABLE > | | | > | > | | YES | > NO | > postgres | staging | source_downloads | BASE TABLE > | | | > | > | | YES | > NO | > postgres | pg_catalog | pg_cast | BASE TABLE > | | | > | > | | YES | > NO | > postgres | pg_catalog | pg_am | BASE TABLE > | | | > | > | | YES | > NO | > postgres | pg_catalog | pg_attrdef | BASE TABLE > | | | > | > | | YES | > NO | > postgres | public | products2 | BASE TABLE > | | | > | > | | YES | > NO | > postgres | information_schema | sql_sizing_profiles | BASE TABLE > | | | > | > | | YES | > NO | > postgres | information_schema | sql_sizing | BASE TABLE > | | | > | > | | YES | > NO | > postgres | information_schema | sql_parts | BASE TABLE > | | | > | > | | YES | > NO | > postgres | information_schema | sql_packages | BASE TABLE > | | | > | > | | YES | > NO | > postgres | information_schema | sql_languages | BASE TABLE > | | | > | > | | YES | > NO | > postgres | information_schema | sql_implementation_info | BASE TABLE > | | | > | > | | YES | > NO | > postgres | public | products | BASE TABLE > | | | > | > | | YES | > NO | > postgres | pg_catalog | pg_collation | BASE TABLE > | | | > | > | | YES | > NO | > postgres | pg_catalog | pg_seclabel | BASE TABLE > | | | > | > | | YES | > NO | > postgres | pg_catalog | pg_default_acl | BASE TABLE > | | | > | > | | YES | > NO | > postgres | pg_catalog | pg_foreign_table | BASE TABLE > | | | > | > | | YES | > NO | > postgres | pg_catalog | pgxc_group | BASE TABLE > | | | > | > | | YES | > NO | > postgres | pg_catalog | pgxc_node | BASE TABLE > | | | > | > | | YES | > NO | > postgres | pg_catalog | pgxc_class | BASE TABLE > | | | > | > | | YES | > NO | > postgres | pg_catalog | pg_foreign_server | BASE TABLE > | | | > | > | | YES | > NO | > postgres | pg_catalog | pg_foreign_data_wrapper | BASE TABLE > | | | > | > | | YES | > NO | > postgres | pg_catalog | pg_extension | BASE TABLE > | | | > | > | | YES | > NO | > postgres | pg_catalog | pg_ts_template | BASE TABLE > | | | > | > | | YES | > NO | > postgres=# \copy staging.mutect from '/tmp/20.mutect.call_stats.out'; > ERROR: relation "mutect" does not exist > > Is this a known bug (version 1.0.3) or is there a different command for > Copy in XC? If it is a bug is there any work around for bulk loading data? > > Thanks, > > Bill West > > > > ------------------------------------------------------------------------------ > LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99! > 1,500+ hours of tutorials including VisualStudio 2012, Windows 8, > SharePoint > 2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack > includes > Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/20/13. > http://pubads.g.doubleclick.net/gampad/clk?id=58041151&iu=/4140/ostg.clktrk > _______________________________________________ > Postgres-xc-bugs mailing list > Pos...@li... > https://lists.sourceforge.net/lists/listinfo/postgres-xc-bugs > > -- -- *Abbas* Architect Ph: 92.334.5100153 Skype ID: gabbasb www.enterprisedb.co <http://www.enterprisedb.com/>m<http://www.enterprisedb.com/> * Follow us on Twitter* @EnterpriseDB Visit EnterpriseDB for tutorials, webinars, whitepapers<http://www.enterprisedb.com/resources-community>and more<http://www.enterprisedb.com/resources-community> |
