Re: BUG #17498: Receive Failed: (error code 1) when importing any csv file from pgAdmin with no explanations - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: BUG #17498: Receive Failed: (error code 1) when importing any csv file from pgAdmin with no explanations
Date
Msg-id CAKFQuwYHVd_zZN3WP2zgOOfTExenqC8=1zWbvDxdBjOJ2+tn0w@mail.gmail.com
Whole thread Raw
In response to Re: BUG #17498: Receive Failed: (error code 1) when importing any csv file from pgAdmin with no explanations  (jam paydavousi <jampaydavousi@yahoo.com>)
Responses Re: BUG #17498: Receive Failed: (error code 1) when importing any csv file from pgAdmin with no explanations
List pgsql-bugs
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.

pgsql-bugs by date:

Previous
From: jam paydavousi
Date:
Subject: Re: BUG #17498: Receive Failed: (error code 1) when importing any csv file from pgAdmin with no explanations
Next
From: David Rowley
Date:
Subject: Re: BUG #17495: Regression in 15beta1 when filtering subquery including row_number window function