Re: Error while loading external data into Postgres table

NO. I dont have any arrays in the table.

- Sravan.

-----Original Message-----
From: shreedhar [mailto:shreedhar(at)lucidindia(dot)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(dot)Bodanapu(at)NextelPartners(dot)com>
To: PGSQL General (E-mail) <mailto:pgsql-general(at)postgresql(dot)org>
Cc: PGSQL Admin (E-mail) <mailto:pgsql-admin(at)postgresql(dot)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.

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.