Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <pgsql-pkg-debian-owner+archive@lists.postgresql.org>)
	id 1gJw7K-0001jS-TM
	for pgsql-pkg-debian@arkaria.postgresql.org; Tue, 06 Nov 2018 07:49:43 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-pkg-debian-owner+archive@lists.postgresql.org>)
	id 1gJw7I-00014n-KL
	for pgsql-pkg-debian@arkaria.postgresql.org; Tue, 06 Nov 2018 07:49:40 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <cb@df7cb.de>)
	id 1gJw7I-00014d-FS; Tue, 06 Nov 2018 07:49:40 +0000
Received: from feynman.df7cb.de ([195.49.152.168])
	by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <cb@df7cb.de>)
	id 1gJw7B-0007Pi-Lb; Tue, 06 Nov 2018 07:49:40 +0000
Received: from msg.df7cb.de (unknown
 [IPv6:2a02:908:1470:e5c0:76e5:bff:fef3:7e00])
	(using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits))
	(Client did not present a certificate)
	by feynman.df7cb.de (Postfix) with ESMTPSA id 42q1sS0vkZz3DxC;
	Tue,  6 Nov 2018 08:49:32 +0100 (CET)
Date: Tue, 6 Nov 2018 08:49:31 +0100
From: Christoph Berg <myon@debian.org>
To: Chapman Flack <chap@anastigmatix.net>
Cc: "pljava-dev@lists.pgfoundry.org" <pljava-dev@lists.pgfoundry.org>,
	pgsql-pkg-debian@postgresql.org, pgsql-pkg-yum@postgresql.org
Subject: Re: PL/Java 1.5.2 - fixes one regression in date conversion in 1.5.1
Message-ID: <20181106074931.GB3898@msg.df7cb.de>
Mail-Followup-To: Christoph Berg <myon@debian.org>,
	Chapman Flack <chap@anastigmatix.net>,
	"pljava-dev@lists.pgfoundry.org" <pljava-dev@lists.pgfoundry.org>,
	pgsql-pkg-debian@postgresql.org, pgsql-pkg-yum@postgresql.org
References: <5BE08D74.2060207@anastigmatix.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <5BE08D74.2060207@anastigmatix.net>
User-Agent: Mutt/1.10.1 (2018-07-13)
List-Id: <pgsql-pkg-debian.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-pkg-debian@lists.postgresql.org>
List-Owner: <mailto:pgsql-pkg-debian-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-pkg-debian>
Precedence: bulk

Re: Chapman Flack 2018-11-05 <5BE08D74.2060207@anastigmatix.net>
> Before 1.5.1, PostgreSQL date, time, and timestamp values could be accessed
> in PL/Java as java.sql.Date, java.sql.Time, and java.sql.Timestamp objects.
> PL/Java 1.5.1 added the option of accessing those values as objects of new
> classes in the Java 8+ java.time package. The new classes are recommended as
> a superior API for accessing dates, times, and timestamps.
> 
> However, one regression resulted in the older conversion between PostgreSQL
> date and java.sql.Date, leading to an error of one day for some dates of the
> year in some time zones. Release 1.5.2 restores the former behavior.

Hi,

1.5.2 doesn't build on Jessie and Trusty anymore (JDK 7):

https://pgdgbuild.dus.dg-i.net/job/postgresql-pljava-binaries/24/
https://pgdgbuild.dus.dg-i.net/job/postgresql-pljava-binaries/24/architecture=amd64,distribution=jessie/console

23:35:43 [ERROR] /<<PKGBUILDDIR>>/pljava-examples/src/main/java/org/postgresql/pljava/example/saxon/S9.java:[35,16] error: package java.time does not exist
23:35:43 [ERROR] /<<PKGBUILDDIR>>/pljava-examples/src/main/java/org/postgresql/pljava/example/saxon/S9.java:[879,12] error: cannot find symbol
23:35:43 [ERROR] symbol:   variable TIME_WITH_TIMEZONE
23:35:43 [ERROR] location: class Types


(There is another issue that apparently maven doesn't like running
several times in parallel, it chokes while reading/writing to ~/.m2.)


I've also enabled -Psaxon-examples - is it correct that no new files
appear in the .deb, but the examples are inside the existing
/usr/share/postgresql/11/pljava/pljava-examples-1.5.2.jar file?

Christoph