Re: AW: new relkind for view

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: AW: new relkind for view
Дата
Msg-id 27714.971733772@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: AW: new relkind for view  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: AW: new relkind for view
Список pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Added to TODO>
>> 
>> I think this is for new todo items:
>> create insert, update and delete rules for simple one table views
>> change elog for complex view ins|upd|del to "cannot {ins|upd|del}
>> [into|from] complex view without an on {ins|upd|del} rule"
>> add the functionality for "with check option" clause of create view

The second of these three items is done already (in the rewriter,
not the executor):

regression=# create view vv1 as select * from int4_tbl;
CREATE
regression=# insert into vv1 values (33);
ERROR:  Cannot insert into a view without an appropriate rule
        regards, tom lane


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

Предыдущее
От: Philip Warner
Дата:
Сообщение: Re: AW: Backup, restore & pg_dump
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: AW: new relkind for view