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

Re: BUG #5794: 'explain' fails, but executing sql is ok.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Peter Speck" <speck(at)vitality(dot)dk>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5794: 'explain' fails, but executing sql is ok.
Date: 2010-12-19 20:34:47
Message-ID: 6881.1292790887@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
"Peter Speck" <speck(at)vitality(dot)dk> writes:
> The following SQL succeeds when executed as-is, but when the SELECT is
> prepended with 'EXPLAIN', it fails with:

> ERROR:  XX000: unexpected CASE WHEN clause: 314
> LOCATION:  get_rule_expr, ruleutils.c:4939

Fixed, thanks for the report!

As a temporary workaround you could just omit "TRUE" from "CASE TRUE
WHEN" ... it's a pretty redundant way to write the expression.

			regards, tom lane

In response to

pgsql-bugs by date

Next:From: Christopher HeadDate: 2010-12-19 22:13:52
Subject: Re: BUG #5559: Full SSL verification fails when hostaddr provided
Previous:From: Peter SpeckDate: 2010-12-19 17:27:47
Subject: BUG #5794: 'explain' fails, but executing sql is ok.

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