Re: functions marked STABLE not allowed to do INSERT

From: Jaime Casanova <systemguards(at)gmail(dot)com>
To: Tino Wildenhain <tino(at)wildenhain(dot)de>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: functions marked STABLE not allowed to do INSERT
Date: 2005-11-14 15:09:06
Message-ID: c2d9e70e0511140709g40275546ubb721304356bc19c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 11/14/05, Tino Wildenhain <tino(at)wildenhain(dot)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 ;)

In response to

Browse pgsql-hackers by date

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