From: Karthikeyan Sundaram <skarthi98@hotmail.com>
To: pgsql-admin@postgresql.org
To: pgsql-sql@postgresql.org
Subject: create view with check option
Date: Sun, 18 Mar 2007 22:38:05 -0700
Message-ID: <BAY131-F39148BA6B3B5CE265CDE4EB0760@phx.gbl> (raw)
In-Reply-To: <BAY131-F14526BA01BB66AA5D4DB75B0810@phx.gbl>
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_te...
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: skarthi98@hotmail.com, pgsql-admin@postgresql.org
Subject: Re: create view with check option
In-Reply-To: <BAY131-F39148BA6B3B5CE265CDE4EB0760@phx.gbl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox