Re: PostgreSQL executing my function too many times during query

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: PostgreSQL executing my function too many times during query
Дата
Msg-id 4524.1210983949@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: PostgreSQL executing my function too many times during query  ("D. Dante Lorenso" <dante@lorenso.com>)
Список pgsql-general
"D. Dante Lorenso" <dante@lorenso.com> writes:
> Tom Lane wrote:
>> I can't reproduce any such problem in 8.2 branch tip, and a desultory
>> scan of the CVS history back to 8.2.4 doesn't turn up any obviously
>> related patches.  Please provide a self-contained test case for what
>> you're seeing.

> I think this is a problem with the BYTEA type.

So far as I can tell, it's a problem with having declared the function
STABLE.  You want IMMUTABLE if you're hoping to have this usage folded
to a constant.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Pg_dump version mismatch
Следующее
От: Chuck Bai
Дата:
Сообщение: Function to return both integer and SETOF refcursor