当我尝试运行pgbench时,在初始化阶段,遇到了一个错误,即"尚未支持此Alter Table命令"。请参阅下面的详细信息:
$ pgbench -i -U postgres -d postgres -p 5433 -h 127.0.0.1
NOTICE: table "pgbench_branches" does not exist, skipping
WARNING: Storage parameter fillfactor is unsupported, ignoring
NOTICE: table "pgbench_tellers" does not exist, skipping
WARNING: Storage parameter fillfactor is unsupported, ignoring
NOTICE: table "pgbench_accounts" does not exist, skipping
WARNING: Storage parameter fillfactor is unsupported, ignoring
NOTICE: table "pgbench_history" does not exist, skipping
creating tables...
10000 tuples done.
20000 tuples done.
30000 tuples done.
40000 tuples done.
50000 tuples done.
60000 tuples done.
70000 tuples done.
80000 tuples done.
90000 tuples done.
100000 tuples done.
**set primary key...
ERROR: This ALTER TABLE command is not yet supported**.
在yugabyte db中,当前,必须将主键条款指定为创建表语句的一部分,并且在事实之后无法通过Alter Table命令添加。
我们最近更改了" PGBENCH"实用程序(作为Yugabyte DB分布的一部分捆绑(,以指定主要键作为创建表语句本身的一部分。
相关问题是: https://github.com/yugabyte/yugabyte-db/issues/1774相关的承诺: https://github.com/yugabyte/yugabyte-db/commit/35B79BC35EEDE9907D917D72E516350A4F6BD281