Re: pgAdmin4 v 5.3 export error

Поиск
Список
Период
Сортировка
От richard coleman
Тема Re: pgAdmin4 v 5.3 export error
Дата
Msg-id CAGA3vBs56aCp-iLGC+Wg2QpAQq8Ydta8GR+Gx-WPM+N5d2_7pw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pgAdmin4 v 5.3 export error  (Khushboo Vashi <khushboo.vashi@enterprisedb.com>)
Ответы Re: pgAdmin4 v 5.3 export error  (Khushboo Vashi <khushboo.vashi@enterprisedb.com>)
Список pgadmin-support
Khushboo, 

That's good to hear.  My Bug #6520 also notes the truncation of lead zeros in numerical values of character columns (something that's missing from Bug # 6507).  Hopefully they will both get fixed soon.

rik.

On Tue, Jun 8, 2021 at 1:01 AM Khushboo Vashi <khushboo.vashi@enterprisedb.com> wrote:
Hi,

This issue has already been reported and it will be fixed soon.

Thanks,
Khushboo

On Tue, Jun 8, 2021 at 1:38 AM richard coleman <rcoleman.ascentgl@gmail.com> wrote:
To whom it may concern, 

I think I've come across a *nasty* bug in the text exporter.  When the table contains character varying field that contain numbers, the text exporter is now appending .0 to the end of cell data that contains numeric values.  It has also started removing any leading zeros.  These zeros are significant (which is why the field they exist in are character varying). 

These two bugs render the text export option useless for this type of data.

Screenshot of the data as shown in pgAdmin4 (note the pro and xref fields):
pg4_bug_tableOutput.png
 
Here is the screenshot of the data that pgAdmin4 now generates (note the pro and xref fields):
pg4_bug_textOutput.png

If someone could look into this that would be appreciated.

thanks.

version 5.3
Python Version 3.8.8
Flask Version 1.1.4
Application Mode: Desktop
OS: Windows 10 Enterprise x64
Вложения

В списке pgadmin-support по дате отправления:

Предыдущее
От: Khushboo Vashi
Дата:
Сообщение: Re: pgAdmin4 v 5.3 export error
Следующее
От: Khushboo Vashi
Дата:
Сообщение: Re: pgAdmin4 v 5.3 export error