From: | Paul Ramsey <pramsey(at)refractions(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Large (?) Views |
Date: | 1999-02-14 19:09:19 |
Message-ID: | 36C71F5F.6AEDBD2F@refractions.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
When trying this view statement:
create view wsrp_view2 as select geog.gis_tag as gis_tag,
(max(geog.area)
- sum(btmm.value*booltoint(btmm.plulabel='FO')) -
sum(btmm.value*booltoint(btmm
.plulabel='FY')))/10000 as land_area, max(geog.area)/10000 as area,
sum(btmm.val
ue*booltoint(btmm.plulabel='FO'))/10000 as FO,
sum(btmm.value*booltoint(btmm.plu
label='FY'))/10000 as FY from geog,btmm where geog.gis_tag =
btmm.gis_tag group
by geog.gis_tag;
PostgreSQL responds with the following:
ERROR: DefineQueryRewrite: rule plan string too big.
What does this mean in real terms? Is there some way to increase a
threshold value to allow us to create a view like this? Or should we
stick to simpler things?
--
__
/
| Paul Ramsey
| Refractions Research
| Email: pramsey(at)refractions(dot)net
| Phone: (250) 885-0632
\_
From | Date | Subject | |
---|---|---|---|
Next Message | Vicente Gras | 1999-02-14 22:03:59 | |
Previous Message | Herouth Maoz | 1999-02-14 17:50:20 | A user can't create a table? |