ERROR: record type has not been registered on CVS head

Started by Stefan Kaltenbrunneralmost 20 years ago2 messages
#1Stefan Kaltenbrunner
stefan@kaltenbrunner.cc

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Stefan Kaltenbrunner (#1)
Re: ERROR: record type has not been registered on CVS head

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