Skip site navigation (1) Skip section navigation (2)

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

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Sebastian <buddhahead(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: broken 'SHOW TABLE'-like query works in 8, not 8.1.1
Date: 2005-12-29 19:58:24
Message-ID: 20051229195824.GA7355@winnie.fuhr.org (view raw or flat)
Thread:
Lists: pgsql-hackers
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

In response to

Responses

pgsql-hackers by date

Next:From: SebastianDate: 2005-12-29 20:12:52
Subject: Re: broken 'SHOW TABLE'-like query works in 8, not 8.1.1
Previous:From: Michael PaesoldDate: 2005-12-29 19:57:16
Subject: Re: plperl vs LC_COLLATE (was Re: Possible savepoint bug)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group