From: jam paydavousi <jampaydavousi@yahoo.com>
To: 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 21:55:51 +0000 (UTC)
Message-ID: <219475353.1702092.1653515751420@mail.yahoo.com> (raw)
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>
Never mind I solved the problem. I had to replace 'INT' with 'BIGINT' forgot 10 digit mobile numbers require 8 bytes.
I will go and close the ticket.
Jam
On Wednesday, May 25, 2022, 02:20:33 PM PDT, jam paydavousi <jampaydavousi@yahoo.com> wrote:
Thank you for following up Tom. I did what you instructed- i.e., filing distinctly from pgAdmin link you provided.
However, I have the same issue when I attempt to import the csv file via the command line interface on mac terminal. It copies 0 rows
postgres-# \copy alove from '/Users/jam/alovel.csv' delimiter ',' csv header;
COPY 0
postgres-#
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 need 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 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
On Wednesday, May 25, 2022, 01:06:14 PM PDT, Tom Lane <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 -- then it'd be
appropriate for this list to look closer.
regards, tom lane
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, 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: <219475353.1702092.1653515751420@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