PostgreSQL 8.4 and up only: Load data from Excel files into PostgreSQL using CSV Loader

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(at)gmail(dot)com

---------- Forwarded message ----------
From: Adrian Wijasa <awijasa(at)gmail(dot)com>
Date: Tue, Aug 24, 2010 at 10:19 PM
Subject: Load data from Excel files into PostgreSQL using CSV Loader
To: pgsql-announce(at)postgresql(dot)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(at)gmail(dot)com(dot)

Thanks!

Adrian Wijasa
Developer
CSV Loader Project