9.1rc1 regression: EXPLAIN on information_schema.key_column_usage

From: Marti Raudsepp <marti(at)juffo(dot)org>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: 9.1rc1 regression: EXPLAIN on information_schema.key_column_usage
Date: 2011-09-07 14:37:12
Message-ID: CABRT9RDfvnLAU7kYdPsxxU-FWvy18F1DBPO-xqA_34XxLtut_g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Yeb Havinga 2011-09-07 14:37:50 Re: [v9.2] Fix Leaky View Problem
Previous Message Kohei KaiGai 2011-09-07 14:21:28 Re: [v9.2] Fix Leaky View Problem