Re: Backend assertion failure on \d

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alan Li <alanwli(at)gmail(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Backend assertion failure on \d
Date: 2009-02-25 16:18:40
Message-ID: 26722.1235578720@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Alan Li <alanwli(at)gmail(dot)com> writes:
> 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:

Thanks for the report. Looks like I forgot to consider the possibility
that type coercion nodes would get inserted atop the CaseTestExpr.
You can break the other paths here too if you try things like
case foo when true then ...
where foo is of a domain over boolean.

Will fix.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2009-02-25 16:40:45 MSVC buildfarm members are all unhappy
Previous Message Magnus Hagander 2009-02-25 15:37:08 Re: Service not starting: Error 1053