problem with views - Mailing list pgsql-general

From cp
Subject problem with views
Date
Msg-id 8tbq3s$gns$1@news.tpi.pl
Whole thread Raw
Responses Re: problem with views  (hubert depesz lubaczewski <depesz@depesz.pl>)
List pgsql-general
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
============




pgsql-general by date:

Previous
From: KuroiNeko
Date:
Subject: Re: FW: Another array question: Join on array elements
Next
From: Igor Roboul
Date:
Subject: Re: timestamp?