public inbox for [email protected]  

help / color / mirror / Atom feed

From: Chapman Flack <[email protected]>
Subject: Re: [Pljava-dev] Draft release notes in preparation for 1.5.1-BETA1
Date: Tue, 20 Jun 2017 10:41:55 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>

On 06/20/2017 10:14 AM, Achilleas Mantzios wrote:
> We got hit by a timestamptz issue which was such a
> PITA to reproduce outside the function (java standalone was OK, psql was
> OK, pljava from psql was OK,  combination of jboss/pgsql/function gave
> wrong offset for the EET time zone) that I am terrified on the idea of
> any change.

Can you recollect any more details of that? That could be interesting
to look into. How was it resolved?

I don't believe there's any change in timestamptz implementation
between current REL1_5_STABLE and master.

If you're able to code up a quick test for the problem you were
having, it's eminently possible to begin a read-write transaction,
load a different PL/Java version, and run your test. If you don't
like what you see, roll back the transaction. :)

> It was some work to get rid of the old installation/schema of
> the previous pljava-snapshot.20120525 . Had to run
> src/pljava-snapshot.20120525.0/src/sql/uninstall.sql and also scrap all
> settings inside postgresql.conf .

When was this, just last January? It should have been easier ...
1.5.0 introduced (and 1.6... also has) automated schema migration.
It would have made sense to take unnecessary settings out of
postgresql.conf, either keeping the necessary ones there, or
moving them to ALTER DATABASE ... SET ..., but there should have
been no need to uninstall a version from 20120525. The auto
migration understands old schemas back to 1.3.0's, from 2006.

Did you try it, and have something go wrong? Do you remember what?

-Chap
_______________________________________________
Pljava-dev mailing list
[email protected]
http://lists.pgfoundry.org/mailman/listinfo/pljava-dev

view thread (12+ 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] Draft release notes in preparation for 1.5.1-BETA1
  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