From: jam paydavousi <jampaydavousi@yahoo.com>
To: David G. Johnston <david.g.johnston@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
Subject: Re: BUG #17498: Receive Failed: (error code 1) when importing any csv file from pgAdmin with no explanations
Date: Wed, 25 May 2022 22:59:27 +0000 (UTC)
Message-ID: <486668902.1716304.1653519567116@mail.yahoo.com> (raw)
In-Reply-To: <CAKFQuwYHVd_zZN3WP2zgOOfTExenqC8=1zWbvDxdBjOJ2+tn0w@mail.gmail.com>
References: <17498-7b8108cfd105f161@postgresql.org>
<1999259.1653509169@sss.pgh.pa.us>
<569491626.1695111.1653513632963@mail.yahoo.com>
<219475353.1702092.1653515751420@mail.yahoo.com>
<CAKFQuwYHVd_zZN3WP2zgOOfTExenqC8=1zWbvDxdBjOJ2+tn0w@mail.gmail.com>
Great point! Thanks again
Jam
On Wednesday, May 25, 2022, 03:15:09 PM PDT, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Wed, May 25, 2022 at 3:04 PM jam paydavousi <jampaydavousi@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 typically consist of digits they are not numbers - they are identifiers. In particular, 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 want to ensure the imported data meets specific criteria.
David J.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: jampaydavousi@yahoo.com, david.g.johnston@gmail.com, tgl@sss.pgh.pa.us, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17498: Receive Failed: (error code 1) when importing any csv file from pgAdmin with no explanations
In-Reply-To: <486668902.1716304.1653519567116@mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox