... - Mailing list pgsql-bugs

From Filip Zawadiak
Subject ...
Date
Msg-id 19990602135802.A1118@wasko.pl
Whole thread Raw
List pgsql-bugs
============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name        :    Filip Zawadiak
Your email address    :    philz@vyx.net


System Configuration
---------------------
  Architecture (example: Intel Pentium)      :   Intel Pentium

  Operating System (example: Linux 2.0.26 ELF)     :   Linux 2.2.5 ELF

  PostgreSQL version (example: PostgreSQL-6.4)  :   PostgreSQL-6.5b

  Compiler used (example:  gcc 2.8.0)        :   egcs-2.91.66


Please enter a FULL description of your problem:
------------------------------------------------
Backend terminates with this message:

TRAP: Failed Assertion("!(tle->expr != ((void *)0)):", File: "tlist.c", Line: 549)

!(tle->expr != ((void *)0)) (0)

Following example is not only one, generally anything what uses
aggregates and inheritance at same time usually doesn't work.

This problem is not a new one, as it was exactly the same with
postgres 6.3...



Please describe a way to repeat the problem.   Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
create table at(a int);
create table bt(b int) inherits (at);
create table ct(c int, d timespan);

insert into bt values (0,0);
insert into ct values (0,'@ 2 hours');

select date_part('day',sum(d)) from ct,at* where c = a;


If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------



pgsql-bugs by date:

Previous
From: jim@reptiles.org (Jim Mercer)
Date:
Subject: 6.5 indexes on timestamp/abstime don't appear to work
Next
From: "C. Arthur Venable III"
Date:
Subject: 10% off custom web design