Re: functions marked STABLE not allowed to do INSERT - Mailing list pgsql-hackers

From Robert Treat
Subject Re: functions marked STABLE not allowed to do INSERT
Date
Msg-id 200511141329.48120.xzilla@users.sourceforge.net
Whole thread Raw
In response to functions marked STABLE not allowed to do INSERT  (Tino Wildenhain <tino@wildenhain.de>)
Responses Re: functions marked STABLE not allowed to do INSERT  (Tino Wildenhain <tino@wildenhain.de>)
List 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 by date:

Previous
From: Chris Browne
Date:
Subject: Re: PostgreSQL roadmap for 8.2 and beyond
Next
From: Merlin Moncure
Date:
Subject: Re: 8.0 -> 8.1 dump duplicate key problem?