Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lrhVZ-0001bt-E2 for pgadmin-hackers@arkaria.postgresql.org; Fri, 11 Jun 2021 13:47:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lrhVY-0007Xf-CR for pgadmin-hackers@arkaria.postgresql.org; Fri, 11 Jun 2021 13:47:36 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lrhVY-0007XP-1I for pgadmin-hackers@lists.postgresql.org; Fri, 11 Jun 2021 13:47:36 +0000 Received: from mail-pf1-x42f.google.com ([2607:f8b0:4864:20::42f]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1lrhVU-0006yF-UJ for pgadmin-hackers@postgresql.org; Fri, 11 Jun 2021 13:47:35 +0000 Received: by mail-pf1-x42f.google.com with SMTP id h12so4509303pfe.2 for ; Fri, 11 Jun 2021 06:47:32 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb-com.20150623.gappssmtp.com; s=20150623; h=mime-version:from:date:message-id:subject:to; bh=rl2CjJytL/WNFexlFeivprCAGNV6/k4laOscjsR9wEY=; b=Yo9l4PaystpiMbB3Yi/wH1jiAK9+s8nr3XYq3r7ukub4T6ESFXEa5NsWg9kDcNr6IJ 1gsYmHj/adoGOcMFQRjU2c1Ju+47R5HiWFVwox/vLqzFm89dKDIndpeTP9RP9WVZcKgc smBQ1uwh92gBFYk+TuYIyz9LZjZNnYEJ5WCKkhodTrNAD5iUUgzMXFF5wBR7qeTXOab+ OrrEjBJCuyYsTjdu6zBxGHYKxX15SJvAcxn1nE17DJVvwEKKly8XibeBkH4jIH3pzZ4R lnR3EUi1fh1DaT+zQLl+AvikUvBsMObAnSsjaX6mDaWZCnHrtY3nVM/bWpBRocPXaQFX cS5Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=rl2CjJytL/WNFexlFeivprCAGNV6/k4laOscjsR9wEY=; b=Ci9Sd427Hx0uE+hz/fTk4RHBLvFsSPkv2cs4DR6BLLNK1JKPfNMCPmtxtbD4SLBY2V doyMgWCcLCxGmmS9eWHQhoDnyayzwB0McUVIuiQ2VUs6Umy27uS/vGW262JK1arxFJbb exfD1kFE2cavdMrlI5QBeWjVGvmgsPeoLdEJR+Kn21ty80WpKoMGGI4mXaAWZHbIb0jS JbDvKBS/ZCNCGSkid1odgHE/jtFyxzK1ts4Zfq8CtEeHBGdoFdOTg/Z+4gyo/Vx5t0Wr XubUE8sCenYQUNUPUl/lbiJu7QTvzxmyz3N4ovIz47qyDwfoBbzutq9J95FxdSPR4NJf Zb4Q== X-Gm-Message-State: AOAM533mvS1qbXtKPoCwmCLe4T0OOpI5kUcveRt4uC5e2T8xyWVidol9 p1YEISmAKZTDRUyvseCrL2JA5famsZ5A03Soi2wOgYlbKCUTwc913DBFf8Dwc0BO5dTip00mSmx uC/Z+Q8pK/JE3b4PETDi9mUR+qtVl73H8wAwFYi+ZnS4xt/w2hl7LC/Y7/T+BjCxnjUoAKDikxK PLtNtULJtpX1/g4W8IYCJqQmtxIaxstPCimnTl/8VI471i8ODs9CTeNJGq2raRqPJ/Uw== X-Google-Smtp-Source: ABdhPJyeutahhYV6Xyb3n9/YG/YDjHclLZDeLM3cQD/HcX/BIx8rGfVPuVdGylrqMto5k9PcBlkxASIUQp3jj41Ey0s= X-Received: by 2002:a05:6a00:2307:b029:2f0:206a:ee13 with SMTP id h7-20020a056a002307b02902f0206aee13mr8424916pfh.79.1623419249726; Fri, 11 Jun 2021 06:47:29 -0700 (PDT) MIME-Version: 1.0 From: Pradip Parkale Date: Fri, 11 Jun 2021 19:17:18 +0530 Message-ID: Subject: [pgAdmin][RM6520]: pgAdmin4 v 5.3 text export error To: pgadmin-hackers Content-Type: multipart/mixed; boundary="000000000000b3e34e05c47dbfd4" X-CLOUD-SEC-AV-Info: enterprisedb,google_mail,monitor X-CLOUD-SEC-AV-Sent: true X-Gm-Spam: 0 X-Gm-Phishy: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000b3e34e05c47dbfd4 Content-Type: multipart/alternative; boundary="000000000000b3e34c05c47dbfd2" --000000000000b3e34c05c47dbfd2 Content-Type: text/plain; charset="UTF-8" Hi Hackers, Please find the attached patch for #6520.Added check to typecast the numeric data while downloading the data in CSV format. -- Thanks & Regards, Pradip Parkale Software Engineer | EnterpriseDB Corporation --000000000000b3e34c05c47dbfd2 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Hackers,

Please find the attached pa= tch for #6520.Added check to typecast the numeric data while downloading=C2= =A0the data in CSV format.

--
Thanks & Regards,
=
Pradip Parkale
Software Engineer | Enter= priseDB Corporation
--000000000000b3e34c05c47dbfd2-- --000000000000b3e34e05c47dbfd4 Content-Type: application/octet-stream; name="RM6520.patch" Content-Disposition: attachment; filename="RM6520.patch" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_kpsdvnpa0 ZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL3Rvb2xzL3NxbGVkaXRvci9fX2luaXRfXy5weSBiL3dl Yi9wZ2FkbWluL3Rvb2xzL3NxbGVkaXRvci9fX2luaXRfXy5weQppbmRleCA3ODBjMDI0M2YuLmM3 ZWM1MjI3NyAxMDA2NDQKLS0tIGEvd2ViL3BnYWRtaW4vdG9vbHMvc3FsZWRpdG9yL19faW5pdF9f LnB5CisrKyBiL3dlYi9wZ2FkbWluL3Rvb2xzL3NxbGVkaXRvci9fX2luaXRfXy5weQpAQCAtMTM1 Nyw3ICsxMzU3LDggQEAgZGVmIHN0YXJ0X3F1ZXJ5X2Rvd25sb2FkX3Rvb2wodHJhbnNfaWQpOgog ICAgIHRyeToKIAogICAgICAgICAjIFRoaXMgcmV0dXJucyBnZW5lcmF0b3Igb2YgcmVjb3Jkcy4K LSAgICAgICAgc3RhdHVzLCBnZW4gPSBzeW5jX2Nvbm4uZXhlY3V0ZV9vbl9zZXJ2ZXJfYXNfY3N2 KHJlY29yZHM9MjAwMCkKKyAgICAgICAgc3RhdHVzLCBnZW4sIGNvbm5fb2JqID0gXAorICAgICAg ICAgICAgc3luY19jb25uLmV4ZWN1dGVfb25fc2VydmVyX2FzX2NzdihyZWNvcmRzPTIwMDApCiAK ICAgICAgICAgaWYgbm90IHN0YXR1czoKICAgICAgICAgICAgIHJldHVybiBtYWtlX2pzb25fcmVz cG9uc2UoCkBAIC0xMzY3LDEzICsxMzY4LDEzIEBAIGRlZiBzdGFydF9xdWVyeV9kb3dubG9hZF90 b29sKHRyYW5zX2lkKToKICAgICAgICAgICAgICkKIAogICAgICAgICByID0gUmVzcG9uc2UoCi0g ICAgICAgICAgICBnZW4oCisgICAgICAgICAgICBnZW4oY29ubl9vYmosCiAgICAgICAgICAgICAg ICAgdHJhbnNfb2JqLAogICAgICAgICAgICAgICAgIHF1b3RlPWJsdWVwcmludC5jc3ZfcXVvdGlu Zy5nZXQoKSwKICAgICAgICAgICAgICAgICBxdW90ZV9jaGFyPWJsdWVwcmludC5jc3ZfcXVvdGVf Y2hhci5nZXQoKSwKICAgICAgICAgICAgICAgICBmaWVsZF9zZXBhcmF0b3I9Ymx1ZXByaW50LmNz dl9maWVsZF9zZXBhcmF0b3IuZ2V0KCksCiAgICAgICAgICAgICAgICAgcmVwbGFjZV9udWxsc193 aXRoPWJsdWVwcmludC5yZXBsYWNlX251bGxzX3dpdGguZ2V0KCkKLSAgICAgICAgICAgICksCisg ICAgICAgICAgICAgICAgKSwKICAgICAgICAgICAgIG1pbWV0eXBlPSd0ZXh0L2NzdicgaWYKICAg ICAgICAgICAgIGJsdWVwcmludC5jc3ZfZmllbGRfc2VwYXJhdG9yLmdldCgpID09ICcsJwogICAg ICAgICAgICAgZWxzZSAndGV4dC9wbGFpbicKZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL3V0aWxz L2RyaXZlci9wc3ljb3BnMi9jb25uZWN0aW9uLnB5IGIvd2ViL3BnYWRtaW4vdXRpbHMvZHJpdmVy L3BzeWNvcGcyL2Nvbm5lY3Rpb24ucHkKaW5kZXggOGZmMDk2M2Y0Li4zYmRkYjlmYTUgMTAwNjQ0 Ci0tLSBhL3dlYi9wZ2FkbWluL3V0aWxzL2RyaXZlci9wc3ljb3BnMi9jb25uZWN0aW9uLnB5Cisr KyBiL3dlYi9wZ2FkbWluL3V0aWxzL2RyaXZlci9wc3ljb3BnMi9jb25uZWN0aW9uLnB5CkBAIC04 NzksNyArODc5LDcgQEAgV0hFUkUgZGIuZGF0bmFtZSA9IGN1cnJlbnRfZGF0YWJhc2UoKSIiIikK IAogICAgICAgICAgICAgcmV0dXJuIHJlc3VsdHMKIAotICAgICAgICBkZWYgZ2VuKHRyYW5zX29i aiwgcXVvdGU9J3N0cmluZ3MnLCBxdW90ZV9jaGFyPSInIiwKKyAgICAgICAgZGVmIGdlbihjb25u X29iaiwgdHJhbnNfb2JqLCBxdW90ZT0nc3RyaW5ncycsIHF1b3RlX2NoYXI9IiciLAogICAgICAg ICAgICAgICAgIGZpZWxkX3NlcGFyYXRvcj0nLCcsIHJlcGxhY2VfbnVsbHNfd2l0aD1Ob25lKToK IAogICAgICAgICAgICAgY3VyLnNjcm9sbCgwLCBtb2RlPSdhYnNvbHV0ZScpCkBAIC04ODksNyAr ODg5LDcgQEAgV0hFUkUgZGIuZGF0bmFtZSA9IGN1cnJlbnRfZGF0YWJhc2UoKSIiIikKICAgICAg ICAgICAgICAgICByZXR1cm4KIAogICAgICAgICAgICAgIyBUeXBlIGNhc3QgdGhlIG51bWVyaWMg dmFsdWVzCi0gICAgICAgICAgICByZXN1bHRzID0gbnVtZXJpY190eXBlY2FzdGVycyhyZXN1bHRz KQorICAgICAgICAgICAgcmVzdWx0cyA9IG51bWVyaWNfdHlwZWNhc3RlcnMocmVzdWx0cywgY29u bl9vYmopCiAKICAgICAgICAgICAgIGhlYWRlciA9IFtdCiAgICAgICAgICAgICBqc29uX2NvbHVt bnMgPSBbXQpAQCAtOTU4LDcgKzk1OCw3IEBAIFdIRVJFIGRiLmRhdG5hbWUgPSBjdXJyZW50X2Rh dGFiYXNlKCkiIiIpCiAgICAgICAgICMgUmVnaXN0ZXJpbmcgYmFjayB0eXBlIGNhc3RlciBmb3Ig bGFyZ2Ugc2l6ZSBkYXRhIHR5cGVzIHRvIHN0cmluZwogICAgICAgICAjIHdoaWNoIHdhcyB1bnJl Z2lzdGVyZWQgYXQgc3RhcnRpbmcKICAgICAgICAgcmVnaXN0ZXJfc3RyaW5nX3R5cGVjYXN0ZXJz KHNlbGYuY29ubikKLSAgICAgICAgcmV0dXJuIFRydWUsIGdlbgorICAgICAgICByZXR1cm4gVHJ1 ZSwgZ2VuLCBzZWxmCiAKICAgICBkZWYgZXhlY3V0ZV9zY2FsYXIoc2VsZiwgcXVlcnksIHBhcmFt cz1Ob25lLAogICAgICAgICAgICAgICAgICAgICAgICBmb3JtYXR0ZWRfZXhjZXB0aW9uX21zZz1G YWxzZSk6CmRpZmYgLS1naXQgYS93ZWIvcGdhZG1pbi91dGlscy9kcml2ZXIvcHN5Y29wZzIvdHlw ZWNhc3QucHkgYi93ZWIvcGdhZG1pbi91dGlscy9kcml2ZXIvcHN5Y29wZzIvdHlwZWNhc3QucHkK aW5kZXggYzZkMDQzZTdiLi4wMjUwZTkzMTYgMTAwNjQ0Ci0tLSBhL3dlYi9wZ2FkbWluL3V0aWxz L2RyaXZlci9wc3ljb3BnMi90eXBlY2FzdC5weQorKysgYi93ZWIvcGdhZG1pbi91dGlscy9kcml2 ZXIvcHN5Y29wZzIvdHlwZWNhc3QucHkKQEAgLTE5OCwyNSArMTk4LDIxIEBAIGRlZiByZWdpc3Rl cl9zdHJpbmdfdHlwZWNhc3RlcnMoY29ubmVjdGlvbik6CiAgICAgICAgIHBzeWNvcGcyLmV4dGVu c2lvbnMucmVnaXN0ZXJfdHlwZSh1bmljb2RlX2FycmF5X3R5cGUsIGNvbm5lY3Rpb24pCiAKIAot ZGVmIGlzX251bWVyaWModmFsKToKLSAgICAiIiJDaGVjayBpZiB2YWx1ZSBpcyBudW1lcmljIG9y IG5vdCIiIgotICAgIHRyeToKLSAgICAgICAgaWYgJy4nIGluIHZhbDoKLSAgICAgICAgICAgIGZs b2F0KHZhbCkKLSAgICAgICAgZWxzZToKLSAgICAgICAgICAgIGludCh2YWwpCi0gICAgZXhjZXB0 IFZhbHVlRXJyb3I6Ci0gICAgICAgIHJldHVybiBGYWxzZQotICAgIHJldHVybiBUcnVlCi0KLQot ZGVmIG51bWVyaWNfdHlwZWNhc3RlcnMocmVzdWx0cyk6CitkZWYgbnVtZXJpY190eXBlY2FzdGVy cyhyZXN1bHRzLCBjb25uX29iaik6CiAgICAgIyBUaGlzIGZ1bmN0aW9uIGlzIHRvIGNvbnZlcnQg cGcgdHlwZXMgdG8gbnVtZWljIHR5cGUgY2FzdGVyCiAKKyAgICBkYXRhID0gW10KKyAgICBmb3Ig b2JqX3R5cGUgaW4gY29ubl9vYmouY29sdW1uX2luZm86CisgICAgICAgIGlmIG9ial90eXBlWyd0 eXBlX2NvZGUnXSBpbiBUT19TVFJJTkdfTlVNRVJJQ19EQVRBVFlQRVM6CisgICAgICAgICAgICBk YXRhLmFwcGVuZChvYmpfdHlwZVsnbmFtZSddKQorCiAgICAgZm9yIHJlc3VsdCBpbiByZXN1bHRz OgogICAgICAgICBmb3Iga2V5LCB2YWx1ZSBpbiByZXN1bHQuaXRlbXMoKToKLSAgICAgICAgICAg IGlmIGlzaW5zdGFuY2UocmVzdWx0W2tleV0sIHN0cikgYW5kIGlzX251bWVyaWMocmVzdWx0W2tl eV0pOgorICAgICAgICAgICAgaWYgaXNpbnN0YW5jZShyZXN1bHRba2V5XSwKKyAgICAgICAgICAg ICAgICAgICAgICAgICAgc3RyKSBhbmQga2V5IGluIGRhdGEgYW5kIG5vdCB2YWx1ZS5pc2RpZ2l0 KCk6CiAgICAgICAgICAgICAgICAgcmVzdWx0W2tleV0gPSBmbG9hdChyZXN1bHRba2V5XSkKKyAg ICAgICAgICAgIGVsaWYgaXNpbnN0YW5jZShyZXN1bHRba2V5XSwgc3RyKSBhbmQga2V5IGluIGRh dGE6CisgICAgICAgICAgICAgICAgcmVzdWx0W2tleV0gPSBpbnQocmVzdWx0W2tleV0pCiAgICAg cmV0dXJuIHJlc3VsdHMKIAogCg== --000000000000b3e34e05c47dbfd4--