Re: BUG #6706: pg_upgrade fails when plpgsql dropped/re-created

cowwoc <cowwoc@bbs.darktech.org> writes:
> Tom Lane-2 wrote
>> That's bizarre.  It sounds like there's something corrupt about your
>> pg_extension system catalog.  Does "select * from pg_extension" show
>> reasonable-looking data?  If so, try "REINDEX TABLE pg_extension".

> This error is quite random, so I'll have to try again the next time I run
> into it. I get the following output when the database is in a "good" state:

If it was non-reproducible, you really should have mentioned that to start
with.  That fact changes the likely causes significantly.  Now I'm
wondering about flaky hardware, for example.

> extname, extowner, extnamespace, extrelocatable, extversion, extconfig,
> extcondition
> "plpgsql";10;11;f;"1.0";"";""
> "hstore";13288111;2200;t;"1.2";"";""

> Is that "reasonable-looking data"?

Yeah, although that OID for the owning role of hstore seems pretty large.

            regards, tom lane