[R-sig-DB] Data type error with RpgSQL on Windows XP SP3 32bit

[Xiaobo Gu]

Hi,
Can you help with this

> driver<-pgSQL(classPath="D:\\rtemp\\postgresql-9.0-801.jdbc4.zip")
> con <- dbConnect(driver, user="postgres", password="postgres",
dbname="demo")
> con
An object of class "pgSQLConnection"
Slot "jc":
[1] "Java-Object{org.postgresql.jdbc4.Jdbc4Connection using 1ce2dd 4}"

Slot "identifier.quote":
[1] "\""

> data <- dbGetQuery(con, "select * from optest.colana")
Error as.Date.default(.jcall(res using jr, "S", "getString", i)) :
do not know how to convert '.jcall(res using jr, "S", "getString", i)' to class
"Date"
>
the DDL is :
CREATE TABLE optest.colana
(
a integer,
b character varying(12),
c date,
d numeric
)

	[[alternative HTML version deleted]]