Thread: Re: Error while loading external data into Postgres table

-----Original Message-----
From: shreedhar [mailto:shreedhar@lucidindia.net]
Sent: Monday, June 02, 2003 2:16 AM
To: Bodanapu, Sravan; PGSQL General (E-mail)
Cc: PGSQL Admin (E-mail)
Subject: Re: [ADMIN] Error while loading external data into Postgres table.

What is delimiter you had given in you 'Copy' command. Is there any array field in your destination table.

 

Sreedhar

 

----- Original Message -----

From: Bodanapu, Sravan

To: PGSQL General (E-mail)

Cc: PGSQL Admin (E-mail)

Sent: Monday, June 02, 2003 12:13 PM

Subject: [ADMIN] Error while loading external data into Postgres table.

Hi Gurus,

I was trying to load data ( from flat file ) to postgres table using "copy" utility in postgres. It throws out an error "ERROR: copy: line 1, array_in: Need to specify dimension"  and fails. I tried with couple of changes and nothing worked. Please advice me accordingly.

Thanks,

- Sravan.

This message, including any attachments, contains confidential information intended for a specific individual and purpose and is protected by law.  If you are not the intended recipient, please contact sender immediately by reply e-mail and destroy all copies.  You are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited.

WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The sender accepts no liability for any damage caused by any virus transmitted by this email. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission.

This message, including any attachments, contains confidential information intended for a specific individual and purpose and is protected by law. If you are not the intended recipient, please contact sender immediately by reply e-mail and destroy all copies. You are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited.

WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The sender accepts no liability for any damage caused by any virus transmitted by this email. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission.

Perhaps you can post the first 10 lines or so of your input file and the
schema in which you are trying to import?

Robert Treat

On Mon, 2003-06-02 at 10:23, Bodanapu, Sravan wrote:
> NO. I dont have any arrays in the table.
>
> - Sravan.
>
> -----Original Message-----
> From: shreedhar [mailto:shreedhar@lucidindia.net]
> Sent: Monday, June 02, 2003 2:16 AM
> To: Bodanapu, Sravan; PGSQL General (E-mail)
> Cc: PGSQL Admin (E-mail)
> Subject: Re: [ADMIN] Error while loading external data into Postgres
> table.
>
>
>
> What is delimiter you had given in you 'Copy' command. Is there any
> array field in your destination table.
>
> Sreedhar
>
> ----- Original Message -----
>
> From: Bodanapu, Sravan <mailto:Sravan.Bodanapu@NextelPartners.com>
> To: PGSQL General (E-mail) <mailto:pgsql-general@postgresql.org>
> Cc: PGSQL Admin (E-mail) <mailto:pgsql-admin@postgresql.org>
> Sent: Monday, June 02, 2003 12:13 PM
> Subject: [ADMIN] Error while loading external data into Postgres table.
>
>
> Hi Gurus,
>
> I was trying to load data ( from flat file ) to postgres table using
> "copy" utility in postgres. It throws out an error "ERROR: copy: line 1,
> array_in: Need to specify dimension"  and fails. I tried with couple of
> changes and nothing worked. Please advice me accordingly.
>
> Thanks,
>
> - Sravan.
>

--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL