Re: vary read_only in SPI calls? or poke at the on-entry snapshot?

2018-09-22 Thread Chapman Flack
On 09/20/18 00:44, Tom Lane wrote: > Chapman Flack writes: >> Would it be unprecedented / be unreasonable / break anything for the >> install_jar function to simply force a CommandCounterIncrement >> at the end of step 1 (after its temporary snapshot has been popped, >> so the former/on-entry

Re: vary read_only in SPI calls? or poke at the on-entry snapshot?

2018-09-21 Thread Chapman Flack
On 09/20/18 00:44, Tom Lane wrote: >> 1. fiddle the loader to always pass read_only => false to SPI calls, >>regardless of the volatility of the function it is loading for. >> 2. leave the loader alone, and adjust install_jar (an infrequent >>operation) to do something heretical with its

Re: vary read_only in SPI calls? or poke at the on-entry snapshot?

2018-09-19 Thread Tom Lane
Chapman Flack writes: > Would it be unprecedented / be unreasonable / break anything for the > install_jar function to simply force a CommandCounterIncrement > at the end of step 1 (after its temporary snapshot has been popped, > so the former/on-entry ActiveSnapshot gets the increment)? The

vary read_only in SPI calls? or poke at the on-entry snapshot?

2018-09-19 Thread Chapman Flack
SOME BACKGROUND: The code for PL/Java functions resides in 'class images'. These are made available, in advance, by loading them from 'jar files' into some tables in the database. When a PL/Java function is called, if the JVM hasn't loaded its class image yet, the JVM calls PL/Java's loader,