Menu
▾
▴
[Postgres-xc-bugs] Copy Command
|
From: West, W. <ww...@uc...> - 2013-09-18 22:18:06
|
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
|
