PostgreSQL: Why not remove index?

Question

I hope to remove index in table, but it occurs not remove index.

CREATE INDEX idx_name ON schema_name.table_name(column1, column2);

And, remove index

DROP INDEX idx_name;

but, it fail.

error message is

ERROR: index "idx_name" does not exist

How I do it?

Łukasz Kamiński · Accepted Answer · 2018-08-28 10:05:33Z

3

You need to specify schema if it isn't in your search path.

DROP INDEX schema_name.idx_name;

To clarify:

The name of the index to be created. No schema name can be included here; the index is always created in the same schema as its parent table

answered Aug 28, 2018 at 10:05

Łukasz Kamiński

6,0401 gold badge26 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1