Postgres Pro
Downloads
Home   >   mailing lists

Thread: pgAdmin4 v 5.3 export error

pgAdmin4 v 5.3 export error

From
richard coleman
Date:
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

Re: pgAdmin4 v 5.3 export error

From
Khushboo Vashi
Date:
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

Re: pgAdmin4 v 5.3 export error

From
richard coleman
Date:
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

Re: pgAdmin4 v 5.3 export error

From
Khushboo Vashi
Date:


On Tue, Jun 8, 2021 at 10:38 AM richard coleman <rcoleman.ascentgl@gmail.com> wrote:
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.

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