Re: functions marked STABLE not allowed to do INSERT

Поиск
Список
Период
Сортировка
От Robert Treat
Тема Re: functions marked STABLE not allowed to do INSERT
Дата
Msg-id 200511141329.48120.xzilla@users.sourceforge.net
обсуждение исходный текст
Ответ на functions marked STABLE not allowed to do INSERT  (Tino Wildenhain <tino@wildenhain.de>)
Ответы Re: functions marked STABLE not allowed to do INSERT  (Tino Wildenhain <tino@wildenhain.de>)
Список pgsql-hackers
On Monday 14 November 2005 10:02, Tino Wildenhain wrote:
> New in 8.1 it seems functions marked STABLE are
> not allowed to have any INSERT statement in them.
>

Try hiding your inserts in seperate volitle sql function that you can select 
inside your stable function.  I think the planner won't be smart enough to 
realize what your doing to it. 

-- 
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL


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

Предыдущее
От: Chris Browne
Дата:
Сообщение: Re: PostgreSQL roadmap for 8.2 and beyond
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: 8.0 -> 8.1 dump duplicate key problem?