Обсуждение: problem with views

Hi.

I'm a new member of a group, and have problem , that I cannot solve by mysel
f.
During a work with RULES for SELECT there were no problems, but they started
, when I added one more field to the
VIEV.
...............
CREATE RULE "_RETv2" AS ON SELECT TO "v2" DO INSTEAD SELECT "t0"."kod", "t0"
."kraj", "t0"."region", "t0"."miasto",

(...)

"t0"."terapie", "t1"."str_kraj", "t2"."str_region", "t0"."mies", "t0"."cena_
na_os"
FROM "oferty" "t0", "kraje" "t1", "regiony" "t2" WHERE ("t1"."id_kraj" = "t0
"."kraj") AND
("t2"."id_region" = "t0"."region");

.............


I received answer: "... Rule string too big"

Is the problem with the limitation of the NUMBER of the fields or LENGTH of
the string describing the rule ???
Is it possible to get through this limitation however???

Thanx in advance.
--
============
Cyppis
Yoxa Consulting
+48 501 560 260
cyprianp@yoxa.com
============

On Fri, Oct 27, 2000 at 01:50:05PM +0200, cp wrote:
> I received answer: "... Rule string too big"
> Is the problem with the limitation of the NUMBER of the fields or LENGTH of
> the string describing the rule ???
> Is it possible to get through this limitation however???

this is the common problem of too big tuples.
limit of each tuple is for now (in most cases) 8kb.
due to interiors of postgresql, rule's definition must fit in single tuple.
this problem will be solved when postgresql 7.1 will arrive (information from
ian wieck).

depesz

--
hubert depesz lubaczewski
------------------------------------------------------------------------
     najwspanialszą rzeczą jaką dało nam nowoczesne społeczeństwo,
      jest niesamowita wręcz łatwość unikania kontaktów z nim ...