Re: [HACKERS] Open 6.3 issues

Поиск
Список
Период
Сортировка
От jwieck@debis.com (Jan Wieck)
Тема Re: [HACKERS] Open 6.3 issues
Дата
Msg-id m0y71MV-000BFRC@orion.SAPserv.Hamburg.dsh.de
обсуждение исходный текст
Ответ на Open 6.3 issues  (Bruce Momjian <maillist@candle.pha.pa.us>)
Ответы Re: [HACKERS] Open 6.3 issues
Список pgsql-hackers
>
> Here is the newest list:
>
> ---------------------------------------------------------------------------
>
> Views on aggregates fail

    Uh oh - Aggregates require a group by clause in the select.
    This is correctly copied into the query action in the views
    pg_rewrite entry. But the rewrite handler doesn't insert it
    into the parsetree. Thus a wrong execution plan in built.

    I'll try some things, but expect to get into trouble if the
    select from the view contains it's own grouping clauses.

    Let's see.

> REVOKE ALL ON pg_user FROM PUBLIC crashes if run many times, cache issue(Jan)

    Done - sent to Marc - not cvs committed yet!


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#======================================== jwieck@debis.com (Jan Wieck) #

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Open 6.3 issues
Следующее
От: Mattias Kregert
Дата:
Сообщение: Re: [HACKERS] Subselects and NOTs