pgadmin csv problems

From: "Michiel Lange" <Michiel_Lange(at)actuera(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: pgadmin csv problems
Date: 2003-12-01 11:10:45
Message-ID: OF1938275F.8E66B495-ONC1256DEF.003BC511@actuera.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hello everybody!

I recently ran into a (hopefully small) problem. When I dump a database to
a CSV file with pgadmin II (Could not find the option to do it in pgAdmin
III, which is a pity, I really like the feature) and then TRUNCATE the
table (so there should be no more data in it) and then try to load fresh
csv-data in the table (or the just dumped table) I get the following
error:

With full debug on:
An error has occurred in Import Wizard:Import
Wizard:frmWizard.cmdOK_click:
Number 0.
Description <empty>

With debugging on Error and SQL Queries:
Number: 9
Description: Subscript out of range.

Any ideas how to solve this? I want the CSV-file imported.
I use pgAdmin II 1.6.0 (pgAdmin III is 1.0.1)
Database is: 7.3.2 (am working on migration to 7.3.4)

I know this used to work some time in the past... but don't know how the
situation was exactly... (which versions I used, that is)
I have full rights to the database.

(The mail can be delayed, because my published email address has changed
(corporate decision). oh well...
Thanks in advance tho!

Michiel Lange

================================================
De informatie opgenomen in dit bericht kan vertrouwelijk zijn en
is uitsluitend bestemd voor de geadresseerde. Indien u dit bericht
onterecht ontvangt, wordt u verzocht de inhoud niet te gebruiken en
de afzender direct te informeren door het bericht te retourneren.
================================================
The information contained in this message may be confidential
and is intended to be exclusively for the addressee. Should you
receive this message unintentionally, please do not use the contents
herein and notify the sender immediately by return e-mail.

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Andreas Pflug 2003-12-01 12:36:11 Re: pgadmin csv problems
Previous Message Andreas Pflug 2003-12-01 11:06:47 Re: pgAdmin III enhancement