public inbox for [email protected]  

help / color / mirror / Atom feed

From: John R Pierce <[email protected]>
Subject: Re: [Pljava-dev] built, now how to install?
Date: Fri, 15 Jan 2016 11:31:05 -0800
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>

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
[email protected]
http://lists.pgfoundry.org/mailman/listinfo/pljava-dev

view thread (14+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected]
  Subject: Re: [Pljava-dev] built, now how to install?
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox