Unable to drop extension dblink - Mailing list pgsql-admin

From Matt Gibbins
Subject Unable to drop extension dblink
Date
Msg-id 07dbf1c4-4871-4348-b41a-d0a800da7465@fastmail.com.au
Whole thread Raw
Responses Re: Unable to drop extension dblink
Re: Unable to drop extension dblink
List 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@lists.postgresql.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.




pgsql-admin by date:

Previous
From: Rui DeSousa
Date:
Subject: Re: Blocking queries on a hot standby?
Next
From: "David G. Johnston"
Date:
Subject: Re: Unable to drop extension dblink