Re: NEEDING HELP: dropping none-existing extension

Axel Rau <Axel.Rau@chaos1.de> writes:
> during upgrade from 11 to 12, pg_upgrade errors out:
> - - -
> could not load library "$libdir/pg_repack": ERROR:  could not access file "$libdir/pg_repack": No such file or
directory
> Database: development
> Database: operations
> Database: pki_op
> - - -
> I find no extension pg_repack, only views with that name in those DBs.
> While trying to drop them, I get:
> - - -
> ERROR: cannot drop schema repack because extension pg_repack requires it HINT: You can drop extension pg_repack
instead.

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

            regards, tom lane