| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-03-19 05:58:13 | Re: [SQL] create view with check option |
| Previous Message | Tom Lane | 2007-03-16 19:34:14 | Re: Problem migrating from 8.0.3 to 8.2.3 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-03-19 05:58:13 | Re: [SQL] create view with check option |
| Previous Message | Phillip Smith | 2007-03-19 04:03:08 | Re: Help with sub query |