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

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: BUG #17498: Receive Failed: (error code 1) when importing any csv file from pgAdmin with no explanations
Дата
Msg-id CAKFQuwYHVd_zZN3WP2zgOOfTExenqC8=1zWbvDxdBjOJ2+tn0w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #17498: Receive Failed: (error code 1) when importing any csv file from pgAdmin with no explanations  (jam paydavousi <jampaydavousi@yahoo.com>)
Ответы Re: BUG #17498: Receive Failed: (error code 1) when importing any csv file from pgAdmin with no explanations  (jam paydavousi <jampaydavousi@yahoo.com>)
Список 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 по дате отправления:

Предыдущее
От: jam paydavousi
Дата:
Сообщение: Re: BUG #17498: Receive Failed: (error code 1) when importing any csv file from pgAdmin with no explanations
Следующее
От: David Rowley
Дата:
Сообщение: Re: BUG #17495: Regression in 15beta1 when filtering subquery including row_number window function