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
>
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 |