Hi.
With the following you can sometimes kill (but always slow down) the psql-S=
erver.
select=20
table1.a,
table1.b
from table2;
I had that problem with this one:
CREATE VIEW akdsummon AS=20
SELECT=20
akdsummonpre.kundennr,=20
(sum(akdsummonpre.SummeGGRKR))::numeric(9,2) as UmsSum,
akdsummonpre.mmon,=20
akdsummonpre.myear=20
FROM auftraege
GROUP BY akdsummonpre.kundennr,=20
akdsummonpre.mmon,=20
akdsummonpre.myear=20
;
I simply forgot to change the auftraege into akdsummonpre.
The bad thing is, that pgadmin hangs too as soon as you leftclick such a vi=
ew.
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 th=
e query."
And then it should quit!
Sincerly
Axel Spallek