Re: broken 'SHOW TABLE'-like query works in 8, not 8.1.1

[Michael Fuhr <mike(at)fuhr(dot)org>]

On Thu, Dec 29, 2005 at 11:14:59AM -0800, Sebastian wrote:
> I have a query that previously worked fine using pg8 on Fedora. Since
> then we've moved to a FreeBSD 6 server running pg8.1.1 and the query
> doesn't seem to ever finish.

How long did you wait?  In one of my tests the query took over three
times as long to finish in 8.1.1 as it did in 8.0.5, but it did finish.
However, EXPLAIN fails in 8.1.1:

test=> EXPLAIN SELECT ...
ERROR:  record type has not been registered

Something about the information_schema.element_types view seems to
be the problem:

test=> EXPLAIN SELECT * FROM information_schema.element_types;
ERROR:  record type has not been registered

-- 
Michael Fuhr