Re: [ADMIN] create view with check option

2007-03-19 Thread Karthikeyan Sundaram
Hi everybody, I have implemented in a different way as advised in the manual. I thought this will be useful for everbody. We don't have check option in the view. Instead we can create a rule to make the view as insertable, updatable or delete. Here is the script. create table test_t

Re: [ADMIN] create view with check option

2007-03-19 Thread Gaetano Mendola
Karthikeyan Sundaram wrote: > Hi Everybody, > >I have 2 versions of postgres 8.1.0 is my production version and > 8.2.1 is my development version. > > I am trying to create a view in my development version (8.2.3) > > create view chnl_vw as select * from channel with check option; > >