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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq