| 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: | Whole Thread | Raw Message | 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? |