Re: BUG #14414: SPI_ERROR_CONNECT on stable plpgsql function used for domain check

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: marcos(dot)castedo(at)anachronics(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #14414: SPI_ERROR_CONNECT on stable plpgsql function used for domain check
Date: 2016-11-06 17:12:40
Message-ID: 6309.1478452360@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

marcos(dot)castedo(at)anachronics(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tsunakawa, Takayuki 2016-11-07 00:49:42 Re: Re: BUG #13755: pgwin32_is_service not checking if SECURITY_SERVICE_SID is disabled
Previous Message Michael Paquier 2016-11-06 12:12:24 Re: BUG #13755: pgwin32_is_service not checking if SECURITY_SERVICE_SID is disabled