From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
---|---|
To: | Axel Spallek <Axel(at)Spallek(dot)ws> |
Cc: | <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: Select Statements freeze. |
Date: | 2003-04-25 17:53:50 |
Message-ID: | 20030425105225.N21596-100000@megazone23.bigpanda.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Thu, 24 Apr 2003, Axel Spallek wrote:
> Hi.
> With the following you can sometimes kill (but always slow down) the psql-Server.
>
> select
> table1.a,
> table1.b
> from table2;
>
> I had that problem with this one:
>
> CREATE VIEW akdsummon AS
>
> SELECT
>
> akdsummonpre.kundennr,
>
> (sum(akdsummonpre.SummeGGRKR))::numeric(9,2) as UmsSum,
>
> akdsummonpre.mmon,
>
> akdsummonpre.myear
>
> FROM auftraege
>
> GROUP BY akdsummonpre.kundennr,
>
> akdsummonpre.mmon,
>
> akdsummonpre.myear
>
> ;
Postgresql has an extension which tries to treat this as
from auftraege, akdsummonpre with no join condition.
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver Elphick | 2003-04-25 18:40:44 | Re: BUG: Infinite syslog() loop |
Previous Message | Tom Lane | 2003-04-25 14:07:32 | Re: pg_restore hangs on locale |