Skip site navigation (1) Skip section navigation (2)

create view with check option

From: "Karthikeyan Sundaram" <skarthi98(at)hotmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Subject: create view with check option
Date: 2007-03-19 05:38:05
Message-ID: BAY131-F39148BA6B3B5CE265CDE4EB0760@phx.gbl (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-sql
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;

   I am getting an error message:

[Error] Script lines: 1-1 --------------------------
ERROR: WITH CHECK OPTION is not implemented
Line: 1

   what does this mean?  I looked at the 8.2.1 manual and found the create 
view has check option.  But it says before 8.2 those options are 
unsupported.

   How can I make this command to work.

Regards
skarthi

_________________________________________________________________
5.5%* 30 year fixed mortgage rate. Good credit refinance. Up to 5 free 
quotes - *Terms 
https://www2.nextag.com/goto.jsp?product=100000035&url=%2fst.jsp&tm=y&search=mortgage_text_links_88_h2a5d&s=4056&p=5117&disc=y&vers=910


In response to

Responses

pgsql-admin by date

Next:From: Tom LaneDate: 2007-03-19 05:58:13
Subject: Re: [SQL] create view with check option
Previous:From: Tom LaneDate: 2007-03-16 19:34:14
Subject: Re: Problem migrating from 8.0.3 to 8.2.3

pgsql-sql by date

Next:From: Tom LaneDate: 2007-03-19 05:58:13
Subject: Re: [SQL] create view with check option
Previous:From: Phillip SmithDate: 2007-03-19 04:03:08
Subject: Re: Help with sub query

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group