Feedback-ID: i6d194797:Fastmail
Message-ID: <07dbf1c4-4871-4348-b41a-d0a800da7465@fastmail.com.au>
Date: Tue, 19 Sep 2023 08:04:33 +1000
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Content-Language: en-AU
From: Matt Gibbins <matt_gibbins@fastmail.com.au>
To: pgsql-admin@lists.postgresql.org
Subject: Unable to drop extension dblink
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/07dbf1c4-4871-4348-b41a-d0a800da7465%40fastmail.com.au>
Precedence: bulk

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.