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.
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? |