From: Matt Gibbins <matt_gibbins@fastmail.com.au>
To: pgsql-admin@lists.postgresql.org
Subject: Unable to drop extension dblink
Date: Tue, 19 Sep 2023 08:04:33 +1000
Message-ID: <07dbf1c4-4871-4348-b41a-d0a800da7465@fastmail.com.au> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: matt_gibbins@fastmail.com.au, pgsql-admin@lists.postgresql.org
Subject: Re: Unable to drop extension dblink
In-Reply-To: <07dbf1c4-4871-4348-b41a-d0a800da7465@fastmail.com.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox