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

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


Stefan

Stefan Kaltenbrunner <stefan@kaltenbrunner.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