unable to drop index because it does not exists

From: Luca Ferrari <fluca1978(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: unable to drop index because it does not exists
Date: 2019-09-23 11:39:19
Message-ID: CAKoxK+5mh58ow1gxD_MieBYONx6yupkfaexPuX+SU7b09nAM5Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
running 11.5 I've got a partitioned table where I want to destroy an
index (on a column that has nothing to do with the partition):

respidb=# \d+ respi.root

Column | Type |
--------------+-----------------------------+-
sen_id | integer |
mis_flusso | integer |
mis_tasso | integer |
mis_velocita | integer |
mis_ora | timestamp without time zone |
pk | bigint |
ts | timestamp without time zone |
Partition key: LIST (date_part('year'::text, mis_ora))
Indexes:
"idx_root_sensore" btree (sen_id)
"idx_ts" btree (ts)
Partitions: respi.y2018 FOR VALUES IN ('2018'), PARTITIONED,
respi.y2019 FOR VALUES IN ('2019'), PARTITIONED,
respi.y2020 FOR VALUES IN ('2020'), PARTITIONED

respidb=# drop index idx_root_sensore;
ERROR: index "idx_root_sensore" does not exist

Of course the index exists:

SELECT oid, relname, relkind FROM pg_class WHERE relname = 'idx_root_sensore';
-[ RECORD 1 ]-------------
oid | 40950
relname | idx_root_sensore
relkind | I

I already did a manual vacuum on the table.
Any idea?

Luca

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Luca Ferrari 2019-09-23 11:44:44 Re: pg_receivexlog or archive_command
Previous Message Andreas Kretschmer 2019-09-23 08:55:39 Re: pg_receivexlog or archive_command