Large (?) Views

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
\_

Browse pgsql-general by date

  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?