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 1ntz7E-0001Wa-TX for pgsql-bugs@arkaria.postgresql.org; Wed, 25 May 2022 22:04:29 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ntz7D-0000Mw-OM for pgsql-bugs@arkaria.postgresql.org; Wed, 25 May 2022 22:04:27 +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 1ntyyt-0000P5-Uq for pgsql-bugs@lists.postgresql.org; Wed, 25 May 2022 21:55:52 +0000 Received: from sonic319-26.consmr.mail.bf2.yahoo.com ([74.6.131.81]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1ntyyp-0003mI-3Q for pgsql-bugs@lists.postgresql.org; Wed, 25 May 2022 21:55:50 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1653515745; bh=Kj79SPU743oNMkpJVmeofxg2YeaGxkL4maGLJgh/J+U=; h=Date:From:To:Cc:In-Reply-To:References:Subject:From:Subject:Reply-To; b=cDUKEY65EzR9hxBeEzNe1PiRbaNkUeUKNdh64AiQVs6dIVUkd6CDoFZ1rjxakaNpcO30Spb3Osdi3U81ZIWJPb4GgMocNBM81y+SOVrOGus2dFrVwDcMh30ZIkvR+YwILDVIhH0xRzrw90wVo9kun8Qa6QIhokmXGRuiR9KJF1+o/5EKjd89XCN3xhUoWerMjLxiVpwaYdM7vOaUCwbNbLiU21+wCYtQ962oKENly51lpCYK4uffOlOm6EoBuvqkbYHvEF4uppGZQ+6E2b+dRX1f3EOjJsMuaUtX3XDcBC6DWbmoIWwvbtzgpuFno6iDeeTgTMSEC9FbKvyz+r07tQ== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1653515745; bh=/ZSiZ6JTv9q7RxXlFJpl6MdvvlJMrHDP1MY09KO3Uqv=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=OUgs6guuWuPekW8ME0VrQihioTwDumB/p75MtT9iJYit4kgwJuJnbho3NN7KjgusDrY4CYnbXM44xvp5tx3L5HAS+1cEoqGE9iKl6OG/piE6oak84+isCEM/Cu9VwTlohVy1Euru0T6EVdah5nIzSlbG692/6m0xivDNdsMVHJIDTgvq7A3y8v7CpmCngHWeg5YQvBVVGbgXrBpumxcgjnRaz8kcnRWP1awwXKhG1P8karLdzz8i2YSakjDfmvwqMmGuTwRX5TMSWP3yFZiSVfewiVj2qEBBtiBrTvRtf+anvIem0dGaSSG1e+cyBivtJh7zcK8gm0/sSg5CvGUwcw== X-YMail-OSG: i_oz0X4VM1k0wJVMzSgCt0zvfAOgjVRGYhfcSHkDAAv28CG4OxW56HZRmx0hexz N.AsW_2hZoXDVYDzp.e8OZeTJfo2pv2n02ygkTmDYcZzksCV4E24fftyV9RwckdzXzPtVKZ81dMn WoBaeZb9GbesrbMrTVWTHz92xYVc0YXIKPEQp39XWcVospCyP9Wx1Fx7J96lvGqnGNBPBRZJm.st 3g3YQ2XCzBM84.jFdbuw_VTYwAcBIYDHn_c48adqK90nLr45yL_NTomQqRrjM1zwLQJ1rbeSOiRS _JmfryPsJllMZREeZ1qTMCwxAdT7yjHDQfPki.VAmBN_CHQdOd5Mry4_J7caDZMnqyU8wgmb0DLs T4r6dV5mT.YPRGdc6Ee9Wc5Jy6ooJzlg9Ba7At_A.cnkOSy6p.1r8Oylyv2XWVoDeYm6IVBCxQkQ Kn6a562mwCgvPayGrg5p78FRJvAYPbc42Ac94bA3PRR9A_yQjc13FVZg9sti.4n0P2RbGjvJyFJz sqVQ.d7fSYQckjcXW2KyyLRJEf_Yx3Ud.hqLtWeB_eHtWiZc8J2pTy6iHn3.4By4cpSS7d5lNNCM 9bmcBKd66cwSwny0ic.OsvZZRpn0_BHJsWoIDRLV5pxbUG4Wzm5TRsSZ9y_Snb8Uh3quCt4siIzL UOXE7iGUixyTL9NpAVoHbIcbtS3rVkVQa2OQWhRYtCIiSrndCVOMDX5ZblArXxOdUEAZpi9gRTw2 JQCGW1BmnyKi9y5Tz6rrLMYglwpj3JZq04mzPeB4NXsbYxFnTcrixPQyFAAwY105AoHj4exz6Hnq e06iIDJ.fRMio_w3D_9Vr2g9sQ1qWCJEI4YMdkP_UfWnu9vs4LLhdZRttI6ECATtlXfJcB6COreh HsBYTuo_Be_P2.EcDSKDkQEowFWfUXTWnqVZD4g6TCZMHYdogZ.1BKzRlhLS7QN20jZJSK4fT2LJ q1U4MTse1hQWyF.chawjUA7zpVIZB8hQkD8p5lBuaf7eXCpUOD3KJrSgMdifVIvcdxi2gyhNl0sE U2Pxjw_6nf5GDS4YIWJiL3cA3mLDfPlmkTUnbBx8S1FU3hXCFnuXLo2bTJGpXlTRvVShNPwRSWxN etha9BdY2db1OzIdyd0cUOiD.qYlVvJHYStMb9FykMsvWLXeH46g4W01naXYvM6Uq_T.AjKr1MZQ YNUwQ7DzPvjP1OJD90iAHzUY0ecG547w7uQZeRhNmG5FQg9LtYX.cmMHusMaUyBBGInGBQqy.XUo WxaZxHi0XeaN5DvavB1LX22PcbVbzFhoXz7Exc1yi6li4DRQt_i2GhNKK.VwioRMQUuVOD3W5uhq IlGgo4FBIH0niIWmpHBqU24UjsKINDYvNLZPGfN28C7WqyQCpbzzSDCyQsi83Z15JkNO95wESksH g74FEHSlj78eb9g_mv1LM2SfCqWMS8fYa7VhI0z10Ki0Z5lr97_FEZLGjq7C2WWUxTOU9OHAHEpY JIoxmWnvGX_aC32yo_nPweLdbcJKiAt3BrpYo27lyyhQk.bvPJ47sIWgNf3kifLJqNOBmUYaIdgL p9dAVioEo2V3RGUHYWXEDbFRQqkVXtITqU8cZHeJ_oBs6E21ZuSq4Q3543aRABDMjdOt_ygCj.x0 0Mg4k4AbEI.OvSrbeSlVddFwnyXEZK5v4MOgLiO2mkQa8h2dgI6iKGo3wpyiddbPFuxdGYSnq5SR KUnlbwYaufwV.PnXwnmV8tkVeTchnn5WRrgO3Kp0ErhxgLoEKyHqgX9YRTMntUWoqZEEDXFoW8IQ OIZWYALNgUoyaqzho4eslzBbM2SQQxpqmauGZlPUgJlR3FCj9bHcM5PnUp5lPpj1F8Y7spKNJoFM P3o_hoJdKpaES9ODvilfwecGyPRWNTtHBPdePYaFNlWmObdot5CDr1E3T1lGvgUUUSwXsV3Z_GvX pIPBYQl3_LCYhqoK2T_EY8kbDBvXZIKrpXS3fRyXTiIz8UiC2s0Fid_jEItO4_B1JDyOlkzLgFNt XbiBmRAxfHfYlkV_emw2kZPhUqp222MNM9nLbD4Elylrv8c0_nd9jwAQ0t9BSrXapMRUm58xqhVk khDbJZv9J4E2G9sH7_tmwtUmDyrx21rIgo7S0JZYc58YOG0FFDvSDhZ4g1yLxdq7g3NQbGg29dny IclkcAx56Pjb15LrSToQCBMEnLPsN937_LIJwdvbo_EmHXSmsNdCy25kto0QSCzliB.lDPekERyi t_innkaeh6KxzmoZOyUt_n0Q- X-Sonic-MF: Received: from sonic.gate.mail.ne1.yahoo.com by sonic319.consmr.mail.bf2.yahoo.com with HTTP; Wed, 25 May 2022 21:55:45 +0000 Date: Wed, 25 May 2022 21:55:51 +0000 (UTC) From: jam paydavousi To: Tom Lane Cc: "pgsql-bugs@lists.postgresql.org" Message-ID: <219475353.1702092.1653515751420@mail.yahoo.com> In-Reply-To: <569491626.1695111.1653513632963@mail.yahoo.com> References: <17498-7b8108cfd105f161@postgresql.org> <1999259.1653509169@sss.pgh.pa.us> <569491626.1695111.1653513632963@mail.yahoo.com> Subject: Re: BUG #17498: Receive Failed: (error code 1) when importing any csv file from pgAdmin with no explanations MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1702091_1094468638.1653515751417" X-Mailer: WebService/1.1.20225 YMailNorrin Content-Length: 8356 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_1702091_1094468638.1653515751417 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Never mind I solved the problem. I had to replace 'INT' with 'BIGINT' =C2= =A0forgot 10 digit mobile numbers require 8 bytes. I will go and close the ticket. =C2=A0 Jam On Wednesday, May 25, 2022, 02:20:33 PM PDT, jam paydavousi wrote: =20 =20 Thank you for following up Tom. =C2=A0I did what you instructed- i.e., fi= ling distinctly from pgAdmin link you provided. However, I have the same issue when I attempt to import the csv file via th= e command line interface on mac terminal. It copies 0 rows postgres-# \copy alove from '/Users/jam/alovel.csv' delimiter ',' csv heade= r; COPY 0 postgres-# I am able to see the same databases that I see in pgAdmin by running ... ps= ql \l ...from the command line. =C2=A0So I am not sure what troubleshooting= I need to do. =C2=A0The csv file that I am trying to import is a small csv= file with 80 rows of 10 digit mobile numbers. =C2=A0And on the SQL side, I= created a table with one column with the same header 'Mobile' with values = of type INT. Any suggestions on troubleshooting from command line interface side? Thank you Jam Paydavousi=C2=A0 On Wednesday, May 25, 2022, 01:06:14 PM PDT, Tom Lane wrote: =20 =20 PG Bug reporting form writes: > Receive Failed: error code 1) when importing any csv file from pgAdmin wi= th > no explanations in the 'Details' section It seems likely that that is a pgAdmin problem, not a problem in core Postgres, in which case this is the wrong place to report it. See https://www.pgadmin.org/support/issues/ instead. If you can reproduce a similarly uninformative failure without using pgAdmin -- say, by using COPY in psql -- then it'd be appropriate for this list to look closer. =C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 regards, tom lane =20 ------=_Part_1702091_1094468638.1653515751417 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Never mind I solved the= problem. I had to replace 'INT' with 'BIGINT'  forgot 10 digit mobile= numbers require 8 bytes.

<= /div>
I will go and close the ticket.=  

Jam

=20
=20
On Wednesday, May 25, 2022, 02:20:33 PM PDT, jam paydav= ousi <jampaydavousi@yahoo.com> wrote:


Thank you for following up Tom.  I did what you ins= tructed- i.e., filing distinctly from pgAdmin link you provided.

However, I have the same issue wh= en I attempt to import the csv file via the command line interface on mac t= erminal. It copies 0 rows

postgr= es-# \copy alove from '/Users/jam/alovel.csv' delimiter ',' csv header;

COPY 0<= /p>

postgres-#

<= font face=3D"Helvetica Neue, Helvetica, Arial, sans-serif" size=3D"2">I am = able to see the same databases that I see in pgAdmin by running ... psql \l= ...from the command line.  So I am not sure what troubleshooting I ne= ed to do.  The csv file that I am trying to import is a small csv file= with 80 rows of 10 digit mobile numbers.  And on the SQL side, I crea= ted a table with one column with the same header 'Mobile' with values of ty= pe INT.

Any suggestions on troubleshooting from command line interface side?=

= Than= k you

Jam Paydavousi
 

=20
=20
On Wednesday, May 25, 2022, 01:06:14 PM PDT, Tom Lane &= lt;tgl@sss.pgh.pa.us> wrote:


PG Bug reporting form <noreply= @postgresql.org> writes:

> Receive Failed: error = code 1) when importing any csv file from pgAdmin with
>= ; no explanations in the 'Details' section


It seems likely that that is a pgAdmin problem, not a problem in=
core Postgres, in which case this is the wrong place to = report it.
See https://www.pgadmin.org/support/issues/ instead.

If you can reproduce a similarly uninformative failure= without
using pgAdmin -- say, by using COPY in psql -- t= hen it'd be
appropriate for this list to look closer.

        &nb= sp;   regards, tom lane

------=_Part_1702091_1094468638.1653515751417--