Postgres Pro
Downloads
Home   >   mailing lists

Re: broken 'SHOW TABLE'-like query works in 8, not 8.1.1 - Mailing list pgsql-hackers

From Michael Fuhr
Subject Re: broken 'SHOW TABLE'-like query works in 8, not 8.1.1
Date
Msg-id 20051229195824.GA7355@winnie.fuhr.org
Whole thread Raw
In response to broken 'SHOW TABLE'-like query works in 8, not 8.1.1  (Sebastian <buddhahead@gmail.com>)
Responses Re: broken 'SHOW TABLE'-like query works in 8, not 8.1.1  (Sebastian <buddhahead@gmail.com>)
Re: broken 'SHOW TABLE'-like query works in 8, not 8.1.1  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Michael Paesold
Date:
Subject: Re: plperl vs LC_COLLATE (was Re: Possible savepoint bug)
Next
From: Sebastian
Date:
Subject: Re: broken 'SHOW TABLE'-like query works in 8, not 8.1.1