From: West, W. <ww...@uc...> - 2013-09-18 22:08:12
|
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 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 |