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)
Список
Дерево обсуждения
AW: new relkind for view Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at>
Re: new relkind for view Mark Hollomon <mhh@mindspring.com>
Re: AW: new relkind for view Bruce Momjian <pgman@candle.pha.pa.us>
Re: AW: new relkind for view Tom Lane <tgl@sss.pgh.pa.us>
Re: AW: new relkind for view Bruce Momjian <pgman@candle.pha.pa.us>
Bruce Momjian 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 по дате отправления