display bigint precision problem in pgAdmin4 ?

From: Alain Dupeyron <adupeyron(at)yahoo(dot)fr>
To: "Pgadmin-support lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org>
Subject: display bigint precision problem in pgAdmin4 ?
Date: 2020-11-06 09:47:31
Message-ID: 1344015657.4855305.1604656051369@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hello,
In PgAdmin 4.27 bigint values are not displayed correctly,
The 2-3 last finest digits are to 000example here 6000 insteaf of 6033 ??

select '2807160139143706033', 2807160139143706033, x'26f50946094bf5b1'::bigint, x'26f50946094bf5b1'::bit(64)

'?column?'    '?column?'    'int8'    'bit'
2807160139143706033    2807160139143706000    2807160139143706000    0010011011110101000010010100011000001001010010111111010110110001

expected result from psql :

      ?column?       |      ?column?       |        int8         |                               bit
---------------------+---------------------+---------------------+------------------------------------------------------------------
 2807160139143706033 | 2807160139143706033 | 2807160139143706033 | 0010011011110101000010010100011000001001010010111111010110110001
(1 ligne)

bug/display problem ?

Thanks

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Nagaraj Raj 2020-11-06 20:22:31 qlalchemy.exc.OperationalError: pgadmin4 startup error after upgrade version to v427
Previous Message Dave Page 2020-11-04 11:12:58 Re: pgadmin4 - which python