Re: BUG #14414: SPI_ERROR_CONNECT on stable plpgsql function used for domain check - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #14414: SPI_ERROR_CONNECT on stable plpgsql function used for domain check
Date
Msg-id 6309.1478452360@sss.pgh.pa.us
Whole thread Raw
In response to BUG #14414: SPI_ERROR_CONNECT on stable plpgsql function used for domain check  (marcos.castedo@anachronics.com)
List pgsql-bugs
marcos.castedo@anachronics.com writes:
> I'm trying to do a domain using stable plpgsql function for value check.
> This isn't working on 9.6.x on plpgsql using assignment from base data type,
> but it works fine on 9.2.x.

Seems to be broken in 9.5 too :-(.  I pushed a fix, thanks for the report!

> --Only fails on stable function, immutable works fine

FWIW, both cases fail for me.  There may be some other effect in whatever
your original case was, but in this specific example an immutable function
fails too.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "MauMau"
Date:
Subject: Re: BUG #13755: pgwin32_is_service not checking if SECURITY_SERVICE_SID is disabled
Next
From: valerijs.gusjkovs@gmail.com
Date:
Subject: BUG #14415: non-breaking space matching in regex as whitespace