Updated on 2023-12-22 GMT+08:00

SP-GiST Index

GS_109120256

errmsg:index row size %lu exceeds maximum %lu for index %s.

errhint:alues larger than a buffer page cannot be indexed.

level:ERROR

GS_109120267

errmsg:SP-GiST inner tuple size %lu exceeds maximum %lu.

errhint:alues larger than a buffer page cannot be indexed.

level:ERROR

GS_109202302

errmsg:index %s contains an inner tuple marked as invalid.

errdetail: This is caused by an incomplete page split at crash recovery before upgrading to PostgreSQL 9.1.

errhint: Please REINDEX it.

level:LOG

GS_109202324

errmsg:picksplit method for column %d of index %s failed.

errhint: The index is not optimal. To optimize it, Optimize the index according to the index selection principles.

level:DEBUG1

GS_109202328

errmsg:index %s contains unexpected zero page at block %u.

errhint: Please REINDEX it.

level:ERROR

GS_109202660

errmsg:column %s contains null values.

errdetail: existing data violate the NOT NULL constraint of new column.

errhint: define DEFAULT constraint also.

level:ERROR