9.1rc1 regression: EXPLAIN on information_schema.key_column_usage - Mailing list pgsql-hackers

From Marti Raudsepp
Subject 9.1rc1 regression: EXPLAIN on information_schema.key_column_usage
Date
Msg-id CABRT9RDfvnLAU7kYdPsxxU-FWvy18F1DBPO-xqA_34XxLtut_g@mail.gmail.com
Whole thread Raw
Responses Re: 9.1rc1 regression: EXPLAIN on information_schema.key_column_usage
List pgsql-hackers
Hi list,

It seems I have found a regression in PostgreSQL 9.1rc1 (from 9.0).

In many cases, running the following query fails:
db=# EXPLAIN select * from information_schema.key_column_usage;
ERROR:  record type has not been registered

However, this is not always reproducible. It seems to occur more
likely on an empty database. At first I suspected uninitialized memory
access somewhere, but valgrind does not highlight anything obvious.
Trying to isolate the part of the view that causes the error also
didn't yield any results.

Similarly, information_schema.triggered_update_columns also
occasionally returns this error, but less reliably.

Regards,
Marti


pgsql-hackers by date:

Previous
From: Kohei KaiGai
Date:
Subject: Re: [v9.2] Fix Leaky View Problem
Next
From: Yeb Havinga
Date:
Subject: Re: [v9.2] Fix Leaky View Problem