create view with check option

Поиск
Список
Период
Сортировка
От Karthikeyan Sundaram
Тема create view with check option
Дата
Msg-id BAY131-F39148BA6B3B5CE265CDE4EB0760@phx.gbl
обсуждение исходный текст
Ответ на system tables inquiry & db Link inquiry  ("Karthikeyan Sundaram" <skarthi98@hotmail.com>)
Ответы Re: create view with check option  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: [ADMIN] create view with check option  ("Karthikeyan Sundaram" <skarthi98@hotmail.com>)
Список 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


В списке pgsql-sql по дате отправления:

Предыдущее
От: "Phillip Smith"
Дата:
Сообщение: Re: Help with sub query
Следующее
От: Tom Lane
Дата:
Сообщение: Re: create view with check option