libre base can not change primary key

When I try to change name of primary key, or change to select another field for primary key, or add any other key, always get error message:Index not found: SYS_IDX_46 in statement [DROP INDEX “SYS_IDX_46” ON “Table”]

Hello,

Please, always post basic info - specific LO version used; OS; database used. All key information for Base questions.

In this case column types are also needed - from & to.

LO version: 6.2.1.2 (x64); OS: windows 7 (x64) Database used: Libre Office Base.

Hello @Bonbonbillo,

You never specified database used. Base is NOT a database. It is a front end to a database. Default databases with Base can be either HSQLDB embedded or Firebird embedded. Also did not reply with field types used. Both were asked for in comments.

Did some test on both types. Was able to do most everything you stated you cannot do with little problem. Depending, saving Base, closing & re-opening helped. Some problems did occur when the Key field was of type Integer and using auto-increment.

This was on Linux Ubuntu 18.04 with LO v6.2.0.3

I have encountered this issue and it turned out that the cause was in having established a relationship between the existing primary key field and another field in another table. Removing the relationship (Tools → Relationships) solves the issue…