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 1lrhpv-0002MG-5q for pgadmin-hackers@arkaria.postgresql.org; Fri, 11 Jun 2021 14:08:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lrhpu-0005Tu-60 for pgadmin-hackers@arkaria.postgresql.org; Fri, 11 Jun 2021 14:08:38 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lrhpt-0005Rb-WC for pgadmin-hackers@lists.postgresql.org; Fri, 11 Jun 2021 14:08:38 +0000 Received: from mail-vs1-xe35.google.com ([2607:f8b0:4864:20::e35]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1lrhpn-0001la-8k for pgadmin-hackers@postgresql.org; Fri, 11 Jun 2021 14:08:36 +0000 Received: by mail-vs1-xe35.google.com with SMTP id z15so3808310vsn.13 for ; Fri, 11 Jun 2021 07:08:31 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb-com.20150623.gappssmtp.com; s=20150623; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=ZjQL8nCsIl+9Ed0oiblfjskv5SEmny2J8LAC+PHnXHU=; b=kK05Xd7rHzVsKA2y3HFr14bs3i9TOGo/hcpbh3naiGopLVrkwOMMBUcnqvkW6EgFYg +4OJplpr7e9DAPQM4SOOqoYTZxYbwBV4FR5sVBYmnwh5V0ZxePuDCoYF+IWMxIKwSoXr o5BX/betPcBWBZO4577rD4KNaWvsjnegNP1WeUyIGQO6J90ILgrduI2lwuja2dHhtKJc 1J2Dg+I2+15gc9zkUgOVygu6TvkOp3FxBxOupZqHGcjrno3vkO0hHbKVbtqpbZWlDkSZ rDq1qfngtk/WYlWPjYYGBAlI33+/x7/BWZZLwqs5r8d5+Si1E3/dbaDwa261DrMqpOdO 4IyA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=ZjQL8nCsIl+9Ed0oiblfjskv5SEmny2J8LAC+PHnXHU=; b=FcBeT7k0UoMkmOWsiNF11tcYtSAKWruBkmKtF3crURBR5zalFDBEY+I0AC5l7b/1L3 1an9NCdQ3pb8qWeSGsqeTfgif+jEwek96t18nB3NmTqKwb6XyM0kJpthM5GagwVDajiR 6Wnglyoe1M917cfDqvzdns3VYlP/ZSS3Z6Fx+2DHuEwRez+TfyGbgcwGLyMu8GCzXyp4 FVpDWcpxgkGUBuURcLbx+8gQR+7zL5pWpSCrvz7hiKrxzjfVc+psCnMAzO+AOY9zwOp7 wfPjMJbVA2viHNKRT8BPqp6+vyxQ4dmzinEcuSxoFGziyTxQLirxSlMR7R5ssxBdka6b ZmYg== X-Gm-Message-State: AOAM532yA3vh0501Ldn6uZ/Mw2V1mSHrWQdjYJ5Zmi1J2FlplWohju8l Z+re3CyzlHcZLs1mxHiOsJfRQiOog+ivED83nZwHTjDbltSdbBJpRtwfN5Oxgyje6RlJUcOiRP2 x9R4JX5iIhnjFFfkZWO1jAHH58h1jrqVUMqk92br6D2LOAgzEYusfdP4UOGhBTdfV3enzlretOS 1pt7q+OKTm9ktInvra839j9zOJIVQdXWx1i9g0WpkrLsuE7FJQwKmswx9xkQ== X-Google-Smtp-Source: ABdhPJw0kZel2419g9oIxChiw/+k7uFQGmnAlSiNfRlZYuArmg+bQTsowMdPWK9jhzUgwO4MBgUYlwlWcvvJfTzCnBs= X-Received: by 2002:a05:6102:115:: with SMTP id z21mr9959781vsq.22.1623420510166; Fri, 11 Jun 2021 07:08:30 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Aditya Toshniwal Date: Fri, 11 Jun 2021 19:37:54 +0530 Message-ID: Subject: Re: [pgAdmin][RM6520]: pgAdmin4 v 5.3 text export error To: Pradip Parkale Cc: pgadmin-hackers Content-Type: multipart/alternative; boundary="000000000000d4750505c47e0a7b" 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 --000000000000d4750505c47e0a7b Content-Type: text/plain; charset="UTF-8" Hi Pradip, Just did a go through to your patch. The variable "data" which you've formed, will be computed for every row even though columns won't change. You should move it up and pass it to gen directly. This will save repeated computations. Secondly, it should not be named as data. It can be like - numeric_cols or numeric_keys. On Fri, Jun 11, 2021 at 7:17 PM Pradip Parkale < pradip.parkale@enterprisedb.com> wrote: > 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 > -- Thanks, Aditya Toshniwal pgAdmin hacker | Sr. Software Engineer | *edbpostgres.com* "Don't Complain about Heat, Plant a TREE" --000000000000d4750505c47e0a7b Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Pradip,

Just did a go through to your patch.=C2=A0
The = variable "data" which you've formed, will be computed for eve= ry row even though columns won't change. You should move it up and pass= it to gen directly. This will save repeated computations.
Secondly, it sh= ould=C2=A0not be named as data. It can be like - numeric_cols or numeric_ke= ys.

On Fri, Jun 11, 2021 at 7:17 PM Pradip Parkale <pradip.parkale@enterprisedb.com>= wrote:
Hi Hackers,

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

--
=
Thanks & Regards,
<= /div>
Pradip Parkale
Software Engineer | = EnterpriseDB Corporation


--
Thanks,
Aditya Toshniwal
pgAdmin hacker=C2=A0| Sr. Softwa= re Engineer | edbpostgres.com<= /font>
"Don't Complain about Heat, Plant a TREE&qu= ot;
--000000000000d4750505c47e0a7b--