Select Statements freeze.

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