From: Koichi S. <koi...@gm...> - 2013-09-23 01:17:09
|
Sorry for the late response. Could you check pgxc_class catalog to see if the table is registered to this catalog as well? Usually, if you've created the table with conventional CREATE TABLE command from one of the coordinators, the definition should have propagated to all the coordinators. We're using COPY command in DBT-2 and does not have any significant problems. --- Koichi Suzuki 2013/9/19 West, William <ww...@uc...> > 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 > > |