Re: display bigint precision problem in pgAdmin4 ?

From: Khushboo Vashi <khushboo(dot)vashi(at)enterprisedb(dot)com>
To: Alain Dupeyron <adupeyron(at)yahoo(dot)fr>
Cc: "Pgadmin-support lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org>
Subject: Re: display bigint precision problem in pgAdmin4 ?
Date: 2020-11-09 02:44:40
Message-ID: CAFOhELcZgdzxHNdnoBw9ELKs2WncQy1g9jDze4w1DtSMTUqG5Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi,

I can not reproduce this issue at my end with pgAdmin v4.27.
Please provide OS, Browser and PG details.

Thanks,
Khushboo

On Fri, Nov 6, 2020 at 3:19 PM Alain Dupeyron <adupeyron(at)yahoo(dot)fr> wrote:

> Hello,
>
> In PgAdmin 4.27 bigint values are not displayed correctly,
> The 2-3 last finest digits are to 000
> example 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
>

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Yambu 2020-11-09 08:32:39 pgadmin 4 dashboard
Previous Message Khushboo Vashi 2020-11-09 02:33:38 Re: qlalchemy.exc.OperationalError: pgadmin4 startup error after upgrade version to v427