problem with views

From: "cp" <cyppis(at)poczta(dot)onet(dot)pl>
To: pgsql-general(at)postgresql(dot)org
Subject: problem with views
Date: 2000-10-27 11:50:05
Message-ID: 8tbq3s$gns$1@news.tpi.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)yoxa(dot)com
============

Responses

Browse pgsql-general by date

  From Date Subject
Next Message paul 2000-10-27 12:00:22 determining current table & record within stored procedure ?
Previous Message Mike E 2000-10-27 11:13:13 Time Difference