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 1nu2x8-0000EK-DR for pgsql-bugs@arkaria.postgresql.org; Thu, 26 May 2022 02:10:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nu2x7-0008Va-A2 for pgsql-bugs@arkaria.postgresql.org; Thu, 26 May 2022 02:10:17 +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 1ntzyK-00049j-Gn for pgsql-bugs@lists.postgresql.org; Wed, 25 May 2022 22:59:20 +0000 Received: from sonic315-14.consmr.mail.bf2.yahoo.com ([74.6.134.124]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1ntzyH-0004Dv-BS for pgsql-bugs@lists.postgresql.org; Wed, 25 May 2022 22:59:19 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1653519554; bh=frFDHvk6BRhDeseIlnkoq5g+73WAT9b8aFfSmj1zFCw=; h=Date:From:To:Cc:In-Reply-To:References:Subject:From:Subject:Reply-To; b=VpQFd8ou7j4+VHQZACs+1AWn/UHSJ8zLDpLM54E8yHPqNRwyCWfQrIE1s6ev7tqKeUjW8c9mlDP63e6yCi7488u1uTltUxqMOnRK8sRBInzolY3jUwVDfJZiwviKwrZxOeuhFjDh3jxw/vfo+SN7mhA6LGrjSAaS+aX03iKXgX/HN7nnEKri27ABJj0Kq2idtkoz63SoebKyS5Abrg9I+NEa+nhzdl5wB0s5iFWkBEbavL8rARRmvbahHI+h/S3djPCq4aPE2Mc65wyQBP2y7N17dv0MWZuju8Rr7dQVqBS5A0X64VqOQTlqt7DhZiBicK7QoldnMBng6rfYcYtKaA== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1653519554; bh=OypwF2j6vzgX2rBANwd1W8l8NbHzX9z+6ykfQQZamdQ=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=hltIYaqlrs0hbuuTA/t8xTtXFHuUtnJ1bJT7wMvmD6oB1RGxs/XzV5lZYyfLT1HA8Zw0EFWZThOeEYPyj1CboVoVa3mhsW8rDpcs84UOJSzGLm0S2YWXvXd5Xmwgho3vr+VrfUYOU2gTXoD6g69dMjUNgEejKMKjI9XYAGmyn2kbTXtmnRy0XSu+tsbrlivCHGjU8VQCifS1E/IQBKZ6CHcrQzO2WhlcXfTuaE/Ye9o+eu/7vZ1QEtKduoS//JMaS383/4l0wuSxbbGPuANB/u3+e0M4ls2zFneefqBXrhWrEeAJLXOSUxQNyNKSF4qvWSE0IEAvTUpR7Jk8lpj3Wg== X-YMail-OSG: 4SqX37sVM1mw9Dt6HjLx9_SEbjjJ.axF1b0tleLJIxCB.wKljozxJuZjZOOuHrI GHoBn9mohOdQ02J6_IH4ZRnKXzOg9.rPoEf2HVYwbkzHIVg8lVLkJtn_GhYNIFRZjywXm1C0JKVY qChHcgHjdJYRFuFyEQjUskgSoVrSsizQLAtTppFNn5fm1qfJ8bFrMAg0UAcNA1Xwi8s.tkPBXoZ0 8ECrq7cm26F2Y51aQEuYe6Ibe_KByxo_HW8HJ9B6amlMO4UxNH5SIbd7U2lbt_tg3Z1vGxmwGoOy etayGNtA6_sAWce25DCHmCUqWmEAx_IZV.wmiObPI44tYlZCNqIAnpIwkZZHAXo.Ii0.V2kq4RkM hyi9EPgyamXsUJoD3P6kN.VX_O7d4SVIi2XdCCX7L51O2sJ1BG_7q.Rwq9VWswJ0Ag0zULKznWLB j8_Px_LwWrR2_hVL0PqDt3NXCi9YY1eAA7Eei.NLHkexj0.uEOZdQHuXlxLAL9CHIy0tN44jFmDB uVFpA.jnJ3iicwrHknpUEZttLmqoeeybxWD8OVDCCHgbP4SQ1kRKDErEmm5CKQrUBp1PuuSOYm3p Ny5sU9eB3ve5.iTZZ_H7TBU3mMEg_klXCFgOM7gmpY7UHToZ5ImHnFOuhVMm1x9U2cSab_n7yeJB noFKlK8Q2ZFrLwipTf3fnNcbkS2KKyf5lw79jfWe8wDS6SnZfk8odtX.u9vsTwwIilbKZi06Deyn CFyBED9Gwy4.Px_.6sFvfVo07ErDhKCYI76eaoHU6jweCkTT3pc4_akbiVUrH9OPx2qojAQfMaAr h0RaO.SF_M5cS7d_GDwlS6OzMqgMSQNciaEkIDUDD7Jkpkwwxv9H2rezx3mx6XGhkTsr2oFkTgij pwzmiVnZY7gW7rviFX_8H1DG4UiTwZwveHtQrOb7GkzzMpEsU26znce6N55bMb1QkFPM5DLDGr7A .lSK3kRBZBKdidHTk4fzYe1wd_iItMOlQGMa0xmL47dkSo1Pwm32T8It2nYjMk8miZKeMUNp0JqD ZmSd_mJ07DlJ2d8RtMQy1R.vCfwRKrVmLndkkQnnFRcR_6nVsSxlDCj.PG2WWmmosbJpwjw8B7tj 1we57AS73p3c5pH9SyH8VQ62ojltxuyl0fSul.w0a6sxK0g7sOTiRHS8HiBVzGQLAwCac4jzYbil eaqWSGKYApETK58u_3V5dGtVFqOFbkgamaPYLJ.dIp6w94o24661IKYpMor0lBL8kXf4MDw_EN8p TdApQ52pwEau5WHmg3oJTpSSIKm5ngtucJqFcJIMlLmjsALI6luUzW7Ec1MES5ldfzgoebxFlBVs XEyD5Qi.Hk8zqAYpn0zuFSoBBx3Lp2uQHatpVdgAIAUkx8eA6dS8Jx.0FDbOx55DGqvSx0zrXD_o MVZd.xzZwlbGEBXTv3jt2Jam82dEO_Bs46john1bmKiSfX8EcoNifa1GyIylOqFW80BiE5j1XnA1 fYZEISKMoe2_iwyL5IJfU.EDR.e3O0utlHSSsoGFCiuFABL9WYxPduzJKUynKU_fDI2jCSi.J8Qf O0v5LcVtP17n7sn066qHCfq1OkytlBlsLarWOwNWGl7cYlBG0xHDhGylcP..Grg.HyjXkthbn1Jq gZ5veI7X9XlMIj_NxzGgluUqb5t8qvPn2xJ9Mvmqg2EGttO7ELZz0dHmbVxbO7iGAbIw_D.bXEvO LCKXs5on76Rg6dA4Cj6jeHz15_6PHnnBVOFAABOQGkB.9GcPYMmh6WdEAMGweCQLWgdA8DTWpIqs JlIg3R6ZHPDTir5bpIWYPraTru3yUqt_GBu58iFDYpLSbwjKQ4YB9LzsQdK9SPKs.mqrTEqgOxkB 6P64ETMbPOXxD.lHdCenBmybJXoc6pEdK8y_ZUvSBiSVZ5tSWlDxVbK6ANTmsri72X9g8PlwQ5UU j2bCHpqmij0WgKwasu6oWkvwhKXNS4Jpso4vYKnyRAVvNPxdAOwBFkYZ7bvuK.lECyEKi_DLDypp UvMmPWD295NMsre7B4JtPcEG9Qgf7S_Uq08aI66yNGiK9uKSFl4MVsYC_ibAF.E2e6loAvYIoTue Ymaow9b52FSwyVtfGv8ACkrzYDpl5B2t6j3uZIHw4PFMVQqyFhjiEDRki4ac2tnb3Zckwi4qwWQP dQNQNmQ5T.8mKidNvvv9.8kRWRfSHz.H7QSRLHXdf01X2Ki1eX77.5dZ4VudEoPBvJFRsZGCdXoG rd2VzxYiiYjBJ0ru3IbdsE2G1k.8HCKGtwX7ZxQ-- X-Sonic-MF: Received: from sonic.gate.mail.ne1.yahoo.com by sonic315.consmr.mail.bf2.yahoo.com with HTTP; Wed, 25 May 2022 22:59:14 +0000 Date: Wed, 25 May 2022 22:59:27 +0000 (UTC) From: jam paydavousi To: "David G. Johnston" Cc: Tom Lane , "pgsql-bugs@lists.postgresql.org" Message-ID: <486668902.1716304.1653519567116@mail.yahoo.com> In-Reply-To: References: <17498-7b8108cfd105f161@postgresql.org> <1999259.1653509169@sss.pgh.pa.us> <569491626.1695111.1653513632963@mail.yahoo.com> <219475353.1702092.1653515751420@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_1716303_446875825.1653519567114" X-Mailer: WebService/1.1.20225 YMailNorrin Content-Length: 4397 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_1716303_446875825.1653519567114 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Great point! =C2=A0Thanks again Jam On Wednesday, May 25, 2022, 03:15:09 PM PDT, David G. Johnston wrote: =20 =20 On Wed, May 25, 2022 at 3:04 PM jam paydavousi w= rote: Never mind I solved the problem. I had to replace 'INT' with 'BIGINT' =C2= =A0forgot 10 digit mobile numbers require 8 bytes. IMO, and that of most modellers I suspect, the use of a numeric type to rep= resent a non-numeric phone number is the problem.=C2=A0 While phone numbers= typically consist of digits they are not numbers - they are identifiers.= =C2=A0 In particular, it makes no sense to perform math operations on them.= =C2=A0 I'd suggest you use "text" for the data type - add a check constrain= t if you want to ensure the imported data meets specific criteria. David J. =20 ------=_Part_1716303_446875825.1653519567114 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Great point!  Thanks ag= ain

Jam

=20
=20
On Wednesday, May 25, 2022, 03:15:09 PM PDT, David G. J= ohnston <david.g.johnston@gmail.com> wrote:


On Wed, May 25, 2022 at 3:04 PM jam paydavousi <jampayd= avousi@yahoo.com> wrote:
=
Never mind I solved the problem. I had to= replace 'INT' with 'BIGINT'  forgot 10 digit mobile numbers require 8= bytes.


IMO, and = that of most modellers I suspect, the use of a numeric type to represent a = non-numeric phone number is the problem.  While phone numbers typicall= y consist of digits they are not numbers - they are identifiers.  In p= articular, it makes no sense to perform math operations on them.  I'd = suggest you use "text" for the data type - add a check constraint if you wa= nt to ensure the imported data meets specific criteria.

David J.
------=_Part_1716303_446875825.1653519567114--