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@refractions.net
| Phone: (250) 885-0632
\_