To create or not to create that index

From: Stefan Knecht <knecht(dot)stefan(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: To create or not to create that index
Date: 2023-08-18 03:37:03
Message-ID: CAP50yQ-nzmVB7amZkTxN3ute4NKyoTKH-3eEnVEJPTNaFSLyOQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2023-08-18 03:41:17 Re: To create or not to create that index
Previous Message Bruce Momjian 2023-08-17 23:39:21 Re: Base files compatibility between PG11 and PG15