Re: functions marked STABLE not allowed to do INSERT

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Cc: Tino Wildenhain <tino(at)wildenhain(dot)de>
Subject: Re: functions marked STABLE not allowed to do INSERT
Date: 2005-11-14 18:29:48
Message-ID: 200511141329.48120.xzilla@users.sourceforge.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Merlin Moncure 2005-11-14 18:39:22 Re: 8.0 -> 8.1 dump duplicate key problem?
Previous Message Chris Browne 2005-11-14 16:29:41 Re: PostgreSQL roadmap for 8.2 and beyond