From: Filip Zawadiak <philz(at)wasko(dot)pl>
To: pgsql-bugs(at)postgresql(dot)org
Subject:
Date: 1999-06-02 11:58:02
Message-ID: 19990602135802.A1118@wasko.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================

Your name : Filip Zawadiak
Your email address : philz(at)vyx(dot)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:
---------------------------------------------------------------------

Browse pgsql-bugs by date

  From Date Subject
Next Message C. Arthur Venable III 1999-06-02 15:18:13 10% off custom web design
Previous Message Jim Mercer 1999-06-02 00:18:59 6.5 indexes on timestamp/abstime don't appear to work