Re: SPI isolation changes

On 2023-07-01 01:47, Tom Lane wrote:
> Seino Yuki <seinoyu(at)oss(dot)nttdata(dot)com> writes:
>> Of course, executing SET TRANSACTION ISOLATION LEVEL with SPI_execute
>> will result in error.
>> ---
>> SPI_execute("SET TRANSACTION ISOLATION LEVEL SERIALIZABLE", false, 0);
>
>> (Log Output)
>> ERROR: SET TRANSACTION ISOLATION LEVEL must be called before any
>> query
>> CONTEXT: SQL statement "SET TRANSACTION ISOLATION LEVEL SERIALIZABLE"
>
> Even if you just did SPI_commit? That *should* fail if you just do
> it right off the bat in a SPI-using procedure, because you're already
> within the transaction that called the procedure. But I think it
> will work if you do SPI_commit followed by this SPI_execute.
>
> regards, tom lane

I'm sorry. I understood wrongly.
SPI_execute(SET TRANSACTION ISOLATION LEVEL ~ ) after executing
SPI_commit succeeded.

Thank you. My problem is solved.

Regards,
--
Seino Yuki
NTT DATA CORPORATION