Index already exist exception upon create index on postgresql

Question

I am using PostgreSQL database. I am creating 10 tables for different companies.In order to access records faster, I am attempting to create indexes on each table. However, PostgreSQL throws an exception for indexes that are created for all companies after the first. Is it not possible to create the same index on different tables within the same database?

wero · Accepted Answer · 2016-02-16 12:53:21Z

4

In Postgres index names must be unique within the same schema. If you omit the name then Postgres will create a unique name for you.

answered Feb 16, 2016 at 12:53

wero

33.1k3 gold badges63 silver badges87 bronze badges

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

2 Comments

user5891223 Over a year ago

Thnx a l aot.. got it. Exactly what you mentioned .

Yoku Over a year ago

IMHO, user5891223, shouldn't it be up voted if you accepted this answer?

Collectives™ on Stack Overflow

Index already exist exception upon create index on postgresql

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related