Re: BUG #13773: BigInt column right padding zero

From: Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz>
To: adolfo-goncalves(dot)junior(at)serpro(dot)gov(dot)br, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #13773: BigInt column right padding zero
Date: 2015-11-12 22:22:26
Message-ID: 56451122.7030809@archidevsys.co.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 13/11/15 01:19, adolfo-goncalves(dot)junior(at)serpro(dot)gov(dot)br wrote:
> The following bug has been logged on the website:
>
> Bug reference: 13773
> Logged by: Adolfo Cavalcante
> Email address: adolfo-goncalves(dot)junior(at)serpro(dot)gov(dot)br
> PostgreSQL version: 9.4.5
> Operating system: Linux Ubuntu
> Description:
>
> We have a Linux server running Postgresql 9.4 and a Java 6 client
> application wich was using the JDBC driver postgresql-9.4-1204.jdbc4.jar.
> After updating to postgresql-9.4-1205.jdbc4.jar driver, Bigint pk columns
> are returning an extra zero at right. We insert 123 in the column, the
> select returns 1230. It's important to say that this behavior is
> intermittent. We saw at the version changelog that somethinq was changed in
> the long->Bigint implementation, it may be a clue.
>
>
Note that Java 6 is no longer publicly supported & Java 7 is approaching
EOL!!!

I suggest that you seriously consider upgrading to Java 8 for both
security & performance reasons - quite apart from all the shiny new
features.

Cheers,
Gavin

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message 张文升 2015-11-13 02:44:07 Re: postgresql downgrade issue
Previous Message Alvaro Herrera 2015-11-12 21:58:41 Re: BUG #13741: vacuumdb does not accept valid password