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. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
