Postgres Pro
Downloads
Home   >   mailing lists

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

From Jaime Casanova
Subject Re: functions marked STABLE not allowed to do INSERT
Date
Msg-id c2d9e70e0511140709g40275546ubb721304356bc19c@mail.gmail.com
Whole thread Raw
In response to functions marked STABLE not allowed to do INSERT  (Tino Wildenhain <tino@wildenhain.de>)
List pgsql-hackers
Tree view 
On 11/14/05, Tino Wildenhain <tino@wildenhain.de> wrote:
> New in 8.1 it seems functions marked STABLE are
> not allowed to have any INSERT statement in them.
>

this is not new, always was said that SATBLE and IMMUTABLE functions
must not modify the database. But beginning with 8.0.0 these kind of
thing are checked at compile time.

--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)

pgsql-hackers by date:

Previous
From: Tino Wildenhain
Date:
Subject: functions marked STABLE not allowed to do INSERT
Next
From: Tom Lane
Date:
Subject: Should a plan node's result tuple slot be read-only to caller?