References: <56945E0E.3000104@hogranch.com> <56945EA8.9090505@anastigmatix.net> <56946D05.9050508@anastigmatix.net> <5698E79E.6040904@hogranch.com> <56990F46.2000309@anastigmatix.net> From: John R Pierce Message-ID: <569948F9.9030603@hogranch.com> Date: Fri, 15 Jan 2016 11:31:05 -0800 MIME-Version: 1.0 In-Reply-To: <56990F46.2000309@anastigmatix.net> Subject: Re: [Pljava-dev] built, now how to install? Content-Type: text/plain; charset="us-ascii"; Format="flowed" On 1/15/2016 7:24 AM, Chapman Flack wrote: >> test failed >> >with what appear to be character encoding errors. my test server was >> >running en_US.UTF8, while I suspect this production site uses >> >POSIX/SQLASCII... > If the server is SQL_ASCII and the only failing test was the > UnicodeRoundTripTest, then PL/Java is working and that's as good > as it's going to get. That particular test doesn't even have a > definable meaning when the server encoding is SQL_ASCII. whale... I re-initdb'd my test vm with POSIX/C locale, and when I load the examples.jar, I get... CONTEXT: SQL statement "CREATE OR REPLACE FUNCTION javatest.complex_send(javatest.complex) RETURNS bytea LANGUAGE java IMMUTABLE RETURNS NULL ON NULL INPUT AS 'UDT[org.postgresql.pljava.example.annotation.ComplexScalar] SEND'" ERROR: requested character too large for encoding: 256 all the other functions load, just that last one fails. this is the same error production showed me a screenshot of when they ran the examples. of course, since this fails, the whole sqlj.install_jar() fails because hte transaction rollsback. unluckily, the main application using this database /requires/ POSIX collation for obscure and historic reasons. its all USASCII data anyways. I believe they used a CREATE DATABASE ... ENCODING 'SQL_ASCII' on a cluster that was initdb'd with UTF8 for equally historic reasons (this config is a prototype, 12 hour time zone differences, and path of least resistance). -- john r pierce, recycling bits in santa cruz _______________________________________________ Pljava-dev mailing list Pljava-dev@lists.pgfoundry.org http://lists.pgfoundry.org/mailman/listinfo/pljava-dev