bug (?) with RULEs with WHERE

Поиск
Список
Период
Сортировка
От Kovacs Zoltan
Тема bug (?) with RULEs with WHERE
Дата
Msg-id Pine.LNX.4.21.0110271256380.4110-100000@pc10.radnoti-szeged.sulinet.hu
обсуждение исходный текст
Ответы Re: bug (?) with RULEs with WHERE  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
I cannot use RULEs with WHERE clauses. What's wrong? Is this a bug? I also
had this problem with 7.1.1. The documentation says this should work.

foo=# SELECT version();                              version
---------------------------------------------------------------------PostgreSQL 7.1.3 on i686-pc-linux-gnu, compiled by
GCCegcs-2.91.66
 
(1 row)

foo=# CREATE TABLE a(foo integer);
CREATE
foo=# CREATE TABLE b(foo integer);
CREATE
foo=# CREATE VIEW c AS SELECT foo FROM a;
CREATE
foo=# CREATE RULE d AS ON INSERT TO c WHERE new.foo=5 DO INSTEAD SELECT foo FROM b;
CREATE
foo=# INSERT INTO c VALUES (5);
ERROR:  Cannot insert into a view without an appropriate rule
foo=# INSERT INTO c VALUES (6);
ERROR:  Cannot insert into a view without an appropriate rule

TIA, Zoltan

--                         Kov\'acs, Zolt\'an                        kovacsz@pc10.radnoti-szeged.sulinet.hu
          http://www.math.u-szeged.hu/~kovzol                        ftp://pc10.radnoti-szeged.sulinet.hu/home/kovacsz
 



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: pgindent run
Следующее
От: Jean-Michel POURE
Дата:
Сообщение: Re: CREATE OR REPLACE VIEW/TRIGGER