postgres 分区与唯一约束

最新推荐文章于 2024-07-19 06:57:08 发布

油头怪

最新推荐文章于 2024-07-19 06:57:08 发布

阅读量4k

点赞数

分类专栏： sql 文章标签： java postgresql

本文链接：https://blog.youkuaiyun.com/weixin_41010294/article/details/121649417

版权

sql 专栏收录该内容

6 篇文章

订阅专栏

创建分区语法

create table partition_name partition of table_name for values from (value) to (value) partition by range (column_name);

创建约束语法

alter table table_name add constraint constraint_name unique (column_name);

org.jkiss.dbeaver.model.sql.DBSQLException: SQL 错误 [0A000]: ERROR: insufficient columns in UNIQUE constraint definition
  Detail: UNIQUE constraint on table "table_name" lacks column "date_time" which is part of the partition key.

	at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementImpl.java:134)

	at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeStatement(SQLQueryJob.java:473)

	at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.lambda$0(SQLQueryJob.java:412)

	at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:148)

	at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeSingleQuery(SQLQueryJob.java:405)

	at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.extractData(SQLQueryJob.java:865)

	at org.jkiss.dbeaver.ui.editors.sql.SQLEditor$QueryResultsContainer.readData(SQLEditor.java:2833)

	at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.lambda$0(ResultSetJobDataRead.java:98)

	at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:148)

	at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.run(ResultSetJobDataRead.java:96)

	at org.jkiss.dbeaver.ui.controls.resultset.ResultSetViewer$17.run(ResultSetViewer.java:3356)

	at org.jkiss.dbeaver.model.runtime.AbstractJob.run(AbstractJob.java:103)

	at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63)

该错误表示：唯一约束必须包含分区键，如果不包含分区键，则无法创建唯一约束。

如：想给id加唯一约束，但表的分区是按照date_time来的，那么加约束的列需要为id,date_time.