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
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 |