From: | Sebastian <buddhahead(at)gmail(dot)com> |
---|---|
To: | Michael Fuhr <mike(at)fuhr(dot)org> |
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 20:12:52 |
Message-ID: | 4e36d31d0512291212o243f894esecaf3cd6d2cf1aca@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
I've waited 10 minutes before cancelling. On pg8 it runs in less than a second
: test=> EXPLAIN SELECT * FROM information_schema.element_types;
: ERROR: record type has not been registered
I can reproduce this...
- sebastian
On 12/29/05, Michael Fuhr <mike(at)fuhr(dot)org> wrote:
> 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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Fuhr | 2005-12-29 20:59:48 | Re: broken 'SHOW TABLE'-like query works in 8, not 8.1.1 |
Previous Message | Michael Fuhr | 2005-12-29 19:58:24 | Re: broken 'SHOW TABLE'-like query works in 8, not 8.1.1 |