Hello:
Due to a bug report from a PostgreSQL 8.3 user, I would suggest to use
CSV Loader only with PostgreSQL 8.4 or higher. This could very likely
happened because I learned PL/pgsql through a PostgreSQL 8.4.4
documentation. I'm planning to read the 8.3 documentation as the
first step to solve this issue.
Here is the reported error:
I got the following error on pgAdminIII.(v1.8.4)
PostgreSQL v8.3.3
Windows Vista Home Premium,
java version "1.6.0_21"
Java(TM) SE Runtime Environment (build 1.6.0_21-b07)
ERROR: syntax error at or near "$1"
LINE 1: $1
^
QUERY: $1
CONTEXT: SQL statement in PL/PgSQL function "f_build_tbl_deps" near line 162
********** Error **********
ERROR: syntax error at or near "$1"
SQL STATE:42601
CONTEXT:SQL statement in PL/PgSQL function "f_build_tbl_deps" near line 162
I managed to reproduce the error he got in PostgreSQL 8.3 only.
Thanks,
Adrian Wijasa
Developer
CSV Loader Project
awijasa@gmail.com
---------- Forwarded message ----------
From: Adrian Wijasa <awijasa@gmail.com>
Date: Tue, Aug 24, 2010 at 10:19 PM
Subject: Load data from Excel files into PostgreSQL using CSV Loader
To: pgsql-announce@postgresql.org
CSV Loader 2.1 has just been released at http://csvloader.sourceforge.net.
It is a Java tool that loads/merges data from Excel CSV files into
PostgreSQL through its JDBC3 interface.
If you need a walkthrough of the program or encounter any trouble/bug,
please don't hesitate to contact me at awijasa@gmail.com.
Thanks!
Adrian Wijasa
Developer
CSV Loader Project