By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE bars_bar (id int primary key);
CREATE TABLE foos_foo (id int primary key, bar_id int);
CREATE INDEX foos_foo_bar_id_efb062ad ON foos_foo(bar_id);
ALTER TABLE foos_foo
ADD CONSTRAINT foos_foo_bar_id_efb062ad_fk_foos_bar_id
FOREIGN KEY (bar_id) REFERENCES bars_bar(id);
Records: 0 Duplicates: 0 Warnings: 0
Records: 0 Duplicates: 0 Warnings: 0
DROP INDEX foos_foo_bar_id_efb062ad ON foos_foo;
Cannot drop index 'foos_foo_bar_id_efb062ad': needed in a foreign key constraint