Re: tsearch comments

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: tsearch comments
Дата
Msg-id 25872.1043334845@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: tsearch comments  ("Bjorn Metzdorf" <bm@turtle-entertainment.de>)
Список pgsql-general
"Bjorn Metzdorf" <bm@turtle-entertainment.de> writes:
> Btw, the error message was confusing. It said that the function has to be
> marked "isImmutable", but there is no such attribute, instead "iscachable"
> had to be used. This seems to be a bug.

Actually the preferred syntax in 7.3 is

    CREATE FUNCTION ... LANGUAGE foo IMMUTABLE

For awhile during 7.3 development you had to write WITH (isImmutable)
but we changed the syntax to be more SQL-spec-compatible.  This error
message seems not to have gotten fixed --- thanks for pointing it out.

            regards, tom lane

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

Предыдущее
От: Björn Metzdorf
Дата:
Сообщение: Re: tsearch comments
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [PERFORM] optimizing query