-
Type:
Bug
-
Status: Resolved
-
Priority:
Critical
-
Resolution: Fixed
-
Affects Version/s: 9.10-HF02, 10.1-SNAPSHOT
-
Component/s: Core VCS
On PostgreSQL, table names are limited to 63 characters. If a complex property happens to have a name with 63 characters, its associated index will then be truncated to the same name and the index creation will fail.
Example :
2018-02-27 14:58:15.814 CET [25332] nuxeo@nuxeo LOG: execute <unnamed>: CREATE TABLE "ksupplierrawmaterialswidget_cv_system_currentlifecyclestate_agg" ("id" varchar(36) NOT NULL, "pos" int4, "item" varchar) 2018-02-27 14:58:15.822 CET [25332] nuxeo@nuxeo LOG: execute <unnamed>: CREATE UNIQUE INDEX "ksupplierrawmaterialswidget_cv_system_currentlifecyclestate_agg_unique_pos" ON "ksupplierrawmaterialswidget_cv_system_currentlifecyclestate_agg" ("id", "pos") 2018-02-27 14:58:15.822 CET [25332] nuxeo@nuxeo ERROR: relation "ksupplierrawmaterialswidget_cv_system_currentlifecyclestate_agg" already exists
- is related to
-
NXP-22724 Database-level integrity constraints on simple lists for PostgreSQL
-
- Resolved
-
