Re: NEEDING HELP: dropping none-existing extension

Axel Rau <Axel(dot)Rau(at)chaos1(dot)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