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

2014-03-12 Thread MauMau
From: "Tom Lane" 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 a

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

2014-03-11 Thread Tom Lane
"MauMau" writes: > From: "Tom Lane" >> When it breaks, we're not going to be concerned. > I may not understand your nuance. Which of the following do you mean? > * PL/Java's design is dangerous in terms of the mixture of single- and > multi-threading, and we cannot be 100% sure whether there'

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

2014-03-11 Thread MauMau
From: "Tom Lane" "MauMau" writes: To put the question in other words, is it safe to load a multi-threaded PL library in the single-threaded backend process, if the PL only calls SPI in the main thread? When it breaks, we're not going to be concerned. I may not understand your nuance. Wh

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

2014-03-08 Thread Tom Lane
"MauMau" writes: > Is PL/Java safe to use in terms of its threading design? I'm going to ask > the PL/Java community about this too, but I'd ask for opinions here because > I believe people in this community have seasoned knowledge of OS and SPI. > To put the question in other words, is it saf