"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 Head||Date: 2010-12-19 22:13:52|
|Subject: Re: BUG #5559: Full SSL verification fails when hostaddr
|Previous:||From: Peter Speck||Date: 2010-12-19 17:27:47|
|Subject: BUG #5794: 'explain' fails, but executing sql is ok.|