BUG #13775: CREATE RULE documentation seems to be wrong under ON SELECT TO DO INSTEAD SELECT Поиск
Список
Период
Сортировка
От needthistool@gmail.com
Тема BUG #13775: CREATE RULE documentation seems to be wrong under ON SELECT TO DO INSTEAD SELECT
Дата
Msg-id 20151113210800.615.72954@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #13775: CREATE RULE documentation seems to be wrong under ON SELECT TO DO INSTEAD SELECT
Список pgsql-bugs
Дерево обсуждения 
The following bug has been logged on the website:

Bug reference:      13775
Logged by:          Seldom
Email address:      needthistool@gmail.com
PostgreSQL version: 9.2.14
Operating system:   Linux 4.1.10-17.31.amzn1.x86_64 #1 (~RHEL 4.8.3-9)
Description:

>From the docs:

"Thus, an ON SELECT rule **effectively** turns the table into a view, whose
visible contents are the rows returned by the rule's SELECT command **rather
than whatever had been stored in the table** (if anything). It is
**considered better style** to write a CREATE VIEW command than to create a
real table and define an ON SELECT rule for it." {'**' emphases added}

As far as I can tell, the above is no longer correct whatsoever; at least on
my own server, the CREATE RULE "_RETURN" syntax **actually** turns the table
into a view, dropping the table in question and creating a new view which
has the same name and columns as the table (undocumented-ly possible only if
there are no indexes, triggers, or foreign-key constraints on the current
table, in addition to no rows, which makes the "if anything" remark pretty
misleading).

The documentation /suggests/ that CREATE VIEW ... be used in place of ON
SELECT TO <table> DO INSTEAD SELECT ... however unless I'm mistaken, this is
actually not a **choice**, merely obfuscated sugar for CREATE VIEW. It does
not appear possible to shadow a table with an alternate selection-clause
which makes the real contents of the table appear different in some way (for
instance, adding a default sorting or if one wasn't specified or such).

I don't know what the consensus is with regard to what this syntax may do in
future, but right now, it appears the docs simply do not relate to the
actual behavior of the codebase.

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

Сайт использует файлы cookie для корректной работы и повышения удобства. Нажимая кнопку «Принять» или продолжая пользоваться сайтом, вы соглашаетесь на их использование в соответствии с Политикой в отношении обработки cookie ООО «ППГ», в том числе на передачу данных из файлов cookie сторонним статистическим и рекламным службам. Вы можете управлять настройками cookie через параметры вашего браузера