From: | "Axel Spallek" <Axel(at)Spallek(dot)ws> |
---|---|
To: | <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Select Statements freeze. |
Date: | 2003-04-24 09:18:20 |
Message-ID: | 003f01c30a42$756776a0$3716a8c0@wann.lan |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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
;
I simply forgot to change the auftraege into akdsummonpre.
The bad thing is, that pgadmin hangs too as soon as you leftclick such a view.
After PGAdmin hangs, you even can't drop that view by psql.
IMHO the backend should report a "Table table1 not found in from part of the query."
And then it should quit!
Sincerly
Axel Spallek
From | Date | Subject | |
---|---|---|---|
Next Message | Paul Sundling("Webdaddy") | 2003-04-24 10:31:11 | pg_restore hangs on locale |
Previous Message | Tom Lane | 2003-04-24 02:31:30 | Re: PostgreSQL 7.3 Installation Error |