Re: pgAdmin4 v 5.3 export error - Mailing list pgadmin-support

From richard coleman
Subject Re: pgAdmin4 v 5.3 export error
Date
Msg-id CAGA3vBs56aCp-iLGC+Wg2QpAQq8Ydta8GR+Gx-WPM+N5d2_7pw@mail.gmail.com
Whole thread Raw
In response to Re: pgAdmin4 v 5.3 export error  (Khushboo Vashi <khushboo.vashi@enterprisedb.com>)
Responses Re: pgAdmin4 v 5.3 export error
List 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
Attachment

pgadmin-support by date:

Previous
From: Khushboo Vashi
Date:
Subject: Re: pgAdmin4 v 5.3 export error
Next
From: Khushboo Vashi
Date:
Subject: Re: pgAdmin4 v 5.3 export error