Re: Is SPI safe to use in multi-threaded PL/Java?

From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
> That, more or less. There is exactly zero provision in the Postgres
> code for multiple threads to exist inside a backend process. It's
> possible that PL/Java manages to completely insulate the Java world
> from the C world, so that the C code never sees more than one thread.
> But any leakage at all in that abstraction is probably going to cause
> bugs; and as I said, we (PG hackers) are not going to consider such
> bugs to be our problem.
>
> On platforms where the standard libc supports threading (which is most,
> these days), I'd be particularly worried about leakage along the path
> java -> libc -> postgres. If libc becomes aware that there are multiple
> threads executing inside the process, it's likely to change behaviors.

I see... even Tom-san is suspicious about the PL/Java's design, or the use
of SPI from code linked with libpthread.so. I'll communicate this to the
PL/Java community.

Regards
MauMau