
> > 2. The executor complains if a DELETE or
> > 	INSERT references a view.

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

Andreas

Tue, 12 Sep 2000 09:42:41 +0200
Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at>
AW: new relkind for view
On Tue, Sep 12, 2000 at 09:42:41AM +0200, Zeugswetter Andreas SB wrote:
>
> 	add the functionality for "with check option" clause of create view
>

I'm not familiar with this. What does it do?

-- 
Mark Hollomon
mhh@mindspring.com

Fri, 15 Sep 2000 13:59:10 -0400
Mark Hollomon <mhh@mindspring.com>
Re: new relkind for view
Added to TODO>

[ Charset ISO-8859-1 unsupported, converting... ]
> 
> > > 2. The executor complains if a DELETE or
> > > 	INSERT references a view.
> 
> 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
> 
> Andreas
> 


-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Mon, 16 Oct 2000 17:14:32 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: AW: new relkind for view
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

Mon, 16 Oct 2000 18:02:52 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: AW: new relkind for view 
TODO updated.

> 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
> 


-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Mon, 16 Oct 2000 18:03:48 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: AW: new relkind for view