Help Center/ Relational Database Service/ Troubleshooting/ RDS for PostgreSQL/ Index Name Containing a Schema Name During Index Creation
Updated on 2024-10-24 GMT+08:00
View PDF
Share

Index Name Containing a Schema Name During Index Creation

Scenario

In the official PostgreSQL syntax, an index name cannot contain a schema name. For example, CREATE UNIQUE INDEX fee_code_desc_uni_idx is a correct index name. If a schema name is added to it, like CREATE UNIQUE INDEX "isp-1".fee_code_desc_uni_idx, a syntax parsing error is reported.

However, when you create an index on an RDS for PostgreSQL 11 instance, the index name can contain a schema name. But RDS for PostgreSQL 12 does not support schema names in index names.

Possible Causes

In RDS for PostgreSQL 11, the syntax parsing of create index is modified. Schema names in an index name can be parsed.

But such modification is not made to RDS for PostgreSQL 12.

Parent topic: RDS for PostgreSQL