Backend assertion failure on \d - Mailing list pgsql-hackers

From Alan Li
Subject Backend assertion failure on \d
Date
Msg-id bc34668d0902242313p45976219q84aaa526e259eb57@mail.gmail.com
Whole thread Raw
Responses Re: Backend assertion failure on \d  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Re: Backend assertion failure on \d  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Running the following against HEAD and REL8_3_6:

create table foo (a varchar(500));
create view bar as select case foo.a when '1' then 'foo' else 'bar' end as fa from foo;
\d bar

Causes as assertion in the backend:

TRAP: FailedAssertion("!(((((Node*)(((list_head(((OpExpr *) w)->args))->data.ptr_value)))->type) == T_CaseTestExpr) || ((((Node*)(((list_head(((OpExpr *) w)->args))->data.ptr_value)))->type) == T_Const))", File: "ruleutils.c", Line: 4587
)
LOG:  server process (PID 28408) was terminated by signal 6: Aborted

Attached is a simple patch that appears to fix this problem, not sure if it suffices in general.

Alan
Attachment

pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Service not starting: Error 1053
Next
From: Dave Page
Date:
Subject: Re: Service not starting: Error 1053