Citus "create_distributed_table"给予"PG::UndefinedColumn"

Question

当尝试使用Citus创建分布式表时，它会给出PG::UndefinedColumn: ERROR: column "x" does not exist

我已经在工人和主数据库上启用了Citus:

SELECT run_command_on_workers($cmd$
CREATE EXTENSION citus;
$cmd$);

我创建了一个复合主键：

ActiveRecord::Base.connection.execute("
ALTER TABLE x DROP CONSTRAINT x_pkey CASCADE;
")
ActiveRecord::Base.connection.execute("
ALTER TABLE x ADD PRIMARY KEY (tenant_id, id);
")

当尝试做：

ActiveRecord::Base.connection.execute("
SELECT create_distributed_table(x, tenant_id);
")

它一直在说：

ActiveRecord::StatementInvalid: PG::UndefinedColumn: ERROR:  column "x" does not exist
LINE 2: SELECT create_distributed_table(x, tenant_id...
^
Caused by PG::UndefinedColumn: ERROR:  column "x" does not exist

有什么事我忘了吗？

Answer 1

表名和列名需要以单引号的文本值形式传递：SELECT create_distributed_table('x'，'tenant_id'(；