Unable to drop extension dblink

From: Matt Gibbins <matt_gibbins(at)fastmail(dot)com(dot)au>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Unable to drop extension dblink
Date: 2023-09-18 22:04:33
Message-ID: 07dbf1c4-4871-4348-b41a-d0a800da7465@fastmail.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

In the process of removing extensions not required on the database I was
in the process of removing the dblink extension from the postgres database.

First attempt to drop the extension failed with 'ERROR: schema
"ag_catalog" does not exist'.

Created the extension and then received the 'ERROR: table "ag_label"
does not exist'.

In response I created the table with a dummy colum 'label'.

Dropping the extension resulted in "ERROR: index
"pgsql-admin(at)lists(dot)postgresql(dot)org"'. So I created the index.

Next attempt resulted in 'ERROR:  column is not in index'.

Now I appear to be stuck in a loop with 'ERROR:  column is not in index'
regardless of any attempt to remove these tables and the original
extension.

Any assistance appreciated.

Regards

Matt.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David G. Johnston 2023-09-19 01:14:20 Re: Unable to drop extension dblink
Previous Message Rui DeSousa 2023-09-18 03:41:31 Re: Blocking queries on a hot standby?