Re: NEEDING HELP: dropping none-existing extension

[Axel Rau <Axel.Rau@xxxxxxxxx>]

Am 04.04.2020 um 18:09 schrieb Tom Lane <tgl@xxxxxxxxxxxxx>:

It is really, really, really difficult to believe that you got that
error if there's not any extension pg_repack in the database.  Even
granting the possibility of catalog corruption, there would have
to be some row in pg_extension containing extname = 'pg_repack', or
the message text could not have been generated.  So look again ...

You are right:

operations=# select * from pg_extension;

  extname  | extowner | extnamespace | extrelocatable | extversion | extconfig | extcondition 

-----------+----------+--------------+----------------+------------+-----------+--------------

 plpgsql   |       10 |           11 | f              | 1.0        |           | 

 adminpack |       10 |           11 | f              | 1.0        |           | 

 pg_repack |    16386 |         2200 | f              | 1.4.5      |           | 

(3 rows)

I was misleaded by pgadmin4 in the 1st place.

psql

drop extension pg_repack cascade ;

did the job. (-:

Thanks a lot, Axel

---
PGP-Key: CDE74120  ☀  computing @ chaos claudius

Attachment: signature.asc
Description: Message signed with OpenPGP