BUG (small): Import CSV via pgAdmin4 does always try to load header row

[Thomas Merkner]

Intro: 

THANK YOU - TO ALL OF YOU - for PostgreSQL!

And sorry for having found this small issue ..

 

Topic: 

CSV import via pgAdmin4

 

Behaviour due to Docu:

http://127.0.0.1:58080/help/help/import_export_data.html?highlight=import

Move the Header switch to the Yes position to include the table header with
the data rows. If you include the table header, the first row of the file
will contain the column names.

 

Bug:

No way to avoid first row in csv (UTF-8, Delimiter is ";") to be included in
import.

(setting switch to "on" and back to "off" didn't help it)

Failure report was akin to "imported string to long for target field" .
which was true .. string in header row was 6 long, field defined as
varchar(2) .. importing ISO language codes.

 

Workaroud: 

copy of csv file withOUT header-row.

Try load --> works perfecty

 

Version:

13, downloaded last Saturday, including pgAdmin, from your website.

 

About pgAdmin4

Version

4.26

Copyright

Copyright (C) 2013 - 2020, The pgAdmin Development Team

Python Version

3.8.3 (tags/v3.8.3:6f8c832, May 13 2020, 22:37:02) [MSC v.1924 64 bit
(AMD64)]

Flask Version

1.0.2

Application Mode

Desktop

 

Before that, no pg existing on my PC (Windows, current version, auto-updates
enabled, Chrome  Version 86.0.4240.183 (Offizieller Build) (64-Bit)).

 

Best regards

 

Thomas Merkner

Business & Systems Consultant
Max-Freygasse 29
A-3400 Klosterneuburg
Tel: +43 (0)664 30 27 320
MailTo:   merk...@aon.at
UID: ATU 48161901

 

Re: SonarQube Fixes #3

[Rahul Shirsat]

Hi Hackers,

Minor sonar issues too fixed. Find the updated patch.

On Mon, Nov 9, 2020 at 2:53 PM Rahul Shirsat 
wrote:

> Hi Hackers,
>
> Please find the attached patch to fix the SonarQube code smells having
> rules:
>
>- Refactor this function to reduce its Cognitive Complexity from 24 to
>the 15 allowed.
>
> Also, corrected one of the backup test cases which were failing in server
> mode.
>
> --
> *Rahul Shirsat*
> Software Engineer | EnterpriseDB Corporation.
>


-- 
*Rahul Shirsat*
Software Engineer | EnterpriseDB Corporation.


sonar_bgprocess_issues_v2.patch
Description: Binary data

Patch for SonarQube code scan fixes

[Nikhil Mohite]

Hi Team,

I have fixed some code smell issues in the SonarQube scan, PFA patch.
Details as follows:

1. Schema dif dependency:

   - 'isChecked' is already declared in the upper scope.

2. User management:

   - Refactor this function to reduce its Cognitive Complexity from 27 to
   the 15 allowed.

3. Debugger:

   - Refactor this function to reduce its Cognitive Complexity from 30 to
   the 15 allowed.
   - Refactor this function to reduce its Cognitive Complexity from 45 to
   the 15 allowed.
   - Refactor this function to reduce its Cognitive Complexity from 50 to
   the 15 allowed.






-- 
*Thanks & Regards,*
*Nikhil Mohite*
*Software Engineer.*
*EDB Postgres* 
*Mob.No: +91-7798364578.*


SonarQubeCodeSmellFixes.patch
Description: Binary data

[pgAdmin4] Enhance the Schema diff GUI validation

[Murtuza Zabuawala]

Hi,

PFA minor patch to add the validation in schema diff which will not allow
the user to compare the same objects in source and target dropdowns.

--
Regards,
Murtuza Zabuawala
*EDB*
*POWER TO POSTGRES*
https://www.edbpostgres.com


Add_validation_schema_diff.patch
Description: Binary data