problem with views

Поиск
Список
Период
Сортировка
От cp
Тема problem with views
Дата
Msg-id 8tbq3s$gns$1@news.tpi.pl
обсуждение исходный текст
Ответы Re: problem with views  (hubert depesz lubaczewski <depesz@depesz.pl>)
Список 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 по дате отправления:

Предыдущее
От: KuroiNeko
Дата:
Сообщение: Re: FW: Another array question: Join on array elements
Следующее
От: Igor Roboul
Дата:
Сообщение: Re: timestamp?