Bruce Momjian <bruce@momjian.us> writes:
> I can't think of how to fix this. Perhaps we need to query the
> pg_extension table as of the SELECT function all.
I think you're misjudging the core of the issue. The same thing
would happen if somebody dropped and recreated the public schema.
Or anything else that we create at initdb time but allow to be
dropped.
regards, tom lane