Postgres Pro
Downloads
Home   >   mailing lists

To create or not to create that index - Mailing list pgsql-general

From Stefan Knecht
Subject To create or not to create that index
Date
Msg-id CAP50yQ-nzmVB7amZkTxN3ute4NKyoTKH-3eEnVEJPTNaFSLyOQ@mail.gmail.com
Whole thread Raw
Responses Re: To create or not to create that index
List pgsql-general
Tree view
Hello

Why does this happen?

profile_aggregates=> create index concurrently foo_idx on agg (status, foots, created_ts);


^CCancel request sent
ERROR:  canceling statement due to user request
profile_aggregates=>
profile_aggregates=>  create index concurrently foo_idx on agg (status, foots, created_ts);
ERROR:  relation " foo_idx" already exists

Are these operations not atomic ?

Cheers

Stefan


pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Base files compatibility between PG11 and PG15
Next
From: "David G. Johnston"
Date:
Subject: Re: To create or not to create that index