使用BENCHMARKSQL工具对kingbase灌数据执行语句删除这些外键时报错constraint does not exist

关键字：

Kingbase,  bmsql_district

内容正文：

问题：删除外键时，报错：

ERROR:  constraint "d_warehouse_fkey" of relation "bmsql_district" does not exist

ERROR:  constraint "h_customer_fkey" of relation "bmsql_history" does not exist

ERROR:  constraint "h_district_fkey" of relation "bmsql_history" does not exist

ERROR:  constraint "no_order_fkey" of relation "bmsql_new_order" does not exist

ERROR:  constraint "o_customer_fkey" of relation "bmsql_oorder" does not exist

ERROR:  constraint "ol_order_fkey" of relation "bmsql_order_line" does not exist

ERROR:  constraint "ol_stock_fkey" of relation "bmsql_order_line" does not exist

ERROR:  constraint "s_warehouse_fkey" of relation "bmsql_stock" does not exist

ERROR:  constraint "s_item_fkey" of relation "bmsql_stock" does not exist

解决方案：在runDatabaseBuild.sh中已经删除外键，则无需该操作

执行结果：

 

相关内容可参考官方产品用户文档中的路径：

https://help.kingbase.com.cn/login