[Pljava-dev] calling pljava function seems to change locale settings

Hallo!

First of all i must confess i am not experienced java user but people
trusted to me maintaining PostgreSQL + PL/Java environment on Solaris 10
Sparc.

We use PostgreSQL 8.3.5 and PL/Java 1.4.0 compiled with GCC from
www.blastwave.org i.e. CSW repostitory and generally thing work as expected.

Now we have a bit strange problem which manifests in certain locale
parameters getting changed after calling PL/Java function from plpgsql
function. I am really not sure it has do to with PL/Java itself but at
the moment it seems so.

I describe my testing and what result i have got.

PG startup skript sets two locale env. variables

export LC_CTYPE=et_EE.UTF-8
export LC_COLLATE=et_EE.UTF-8
export LC_NUMERIC=C

and postgresql.conf has

lc_messages = 'et_EE.UTF-8' # locale for system error message
lc_monetary = 'et_EE.UTF-8' # locale for monetary formatting
lc_numeric = 'C' # locale for number formatting
lc_time = 'et_EE.UTF-8' # locale for time formatting

I have java class helloworld.java essentially compiled from

package com.mycompany.helloworld;

public class HelloWorld {

public static String helloWorld() {
return "Hello World";
}
}

and what i loaded into database

CREATE OR REPLACE FUNCTION helloworld()
RETURNS "varchar" AS
'com.mycompany.helloworld.HelloWorld.helloWorld'
LANGUAGE 'java' VOLATILE;

and after saying it gives

$ psql -U postgres -h localhost -c 'select * from helloworld();' db

helloworld
-----------------
Hello World
(1 row)

And i call it from plpgsql function like this

DECLARE
txt varchar;
BEGIN
perform sqlj.print_locale();
perform helloworld();
perform sqlj.print_locale();
txt:='test function';
return txt;
END;

where sqlj.print_locale() is plperlu function assisting to print locale
parameters before and after calling helloworld() and contains

use POSIX qw(locale_h);

open (fh, '>>/tmp/locale.log');
print fh "start\n";
$lokaat{LC_CTYPE}=setlocale(LC_CTYPE);
$lokaat{LC_TIME}=setlocale(LC_TIME);
$lokaat{LC_COLLATE}=setlocale(LC_COLLATE);
$lokaat{LC_MESSAGES}=setlocale(LC_MESSAGES);
$lokaat{LC_MONETARY}=setlocale(LC_MONETARY);
$lokaat{LC_NUMERIC}=setlocale(LC_NUMERIC);

while ( my ($key, $value) = each(%lokaat) ) {
print fh "$key => $value\n";
}
print fh "end\n";
close fh;

return "i am print_locale";

And the result is

beginning
LC_CTYPE => et_EE.UTF-8
LC_NUMERIC => C
LC_MONETARY => C
LC_TIME => C
LC_MESSAGES => et_EE.UTF-8
LC_COLLATE => et_EE.UTF-8
end
beginning
LC_CTYPE => et_EE.UTF-8
LC_NUMERIC => et_EE.UTF-8
LC_MONETARY => et_EE.UTF-8
LC_TIME => et_EE.UTF-8
LC_MESSAGES => et_EE.UTF-8
LC_COLLATE => et_EE.UTF-8
end

I also tried to call from plpgsql plperlu function but in that case
locale parameters remained the same.

If somebody suggests what to investigate further or to change to
accomplish that these variables (esp. LC_NUMERIC) stay unchanged i would
be very grateful.

Best regards,

Imre