Postgres Pro
Downloads
Home   >   mailing lists

Re: Explain verbose query with CTE - Mailing list pgsql-general

From Tom Lane
Subject Re: Explain verbose query with CTE
Date
Msg-id 14359.1334954462@sss.pgh.pa.us
Whole thread Raw
In response to Explain verbose query with CTE  (Bartosz Dmytrak <bdmytrak@gmail.com>)
Responses Re: Explain verbose query with CTE  (Bartosz Dmytrak <bdmytrak@gmail.com>)
List pgsql-general
Tree view 
Bartosz Dmytrak <bdmytrak@gmail.com> writes:
> This e-mail is reposted form pgadmin support mailing list. This problem
> looks like related with postgres not pgAdmin.
> [ EXPLAIN VERBOSE yields a "cache lookup failed" error ]

Huh, yeah, that's a backend bug all right.  I thought at first you might
have a catalog-corruption problem, but I can reproduce the failure here
from your example.  Most likely EXPLAIN is getting confused about which
Var belongs to which table.  Will look into it.

            regards, tom lane

pgsql-general by date:

Previous
From: Eliot Gable
Date:
Subject: Re: LOCK TABLE is not allowed in a non-volatile function
Next
From: Bartosz Dmytrak
Date:
Subject: Re: Explain verbose query with CTE