Re: ERROR: record type has not been registered on CVS head

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: ERROR: record type has not been registered on CVS head
Date: 2006-04-08 18:52:11
Message-ID: 25381.1144522331@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc> writes:
> While trying to help somebody on IRC with slow queries against
> information_schema i stumbled across the following EXPLAIN buglet (much
> reduced from the original one and does not make a lot of sense therefore):

> foo=# explain SELECT * FROM information_schema.constraint_column_usage
> JOIN information_schema.key_column_usage ON
> key_column_usage.constraint_name = constraint_column_usage.constraint_name;
> ERROR: record type has not been registered

I've applied a patch for this in HEAD, but I'm a bit hesitant to
back-patch it without more testing. Since the consequence of the bug
is only inability to get EXPLAIN output, the most prudent course might
be to leave it unfixed in 8.1.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Markus Schiltknecht 2006-04-08 18:54:35 Re: Support Parallel Query Execution in Executor
Previous Message Jonah H. Harris 2006-04-08 18:20:21 Re: How to implement oracle like rownum(function or seudocolumn)