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

cowwoc <cowwoc(at)bbs(dot)darktech(dot)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