8.0.3 parse errors where 7.x was ok

Поиск
Список
Период
Сортировка
От Nick Johnson
Тема 8.0.3 parse errors where 7.x was ok
Дата
Msg-id 20050809164256.D7871@turing.morons.org
обсуждение исходный текст
Ответы Re: 8.0.3 parse errors where 7.x was ok  (Kris Jurka <books@ejurka.com>)
Re: 8.0.3 parse errors where 7.x was ok  (Oliver Jowett <oliver@opencloud.com>)
Список pgsql-jdbc
I'm getting a new exception when upgrading to Postgres 8.0.3 with the JDBC
drivers it builds:

java.sql.SQLException: ERROR: parse error at or near "$1"

This is happening with the following bit of code:

     105         try {
     106             s = c.prepareStatement("select now() - interval ?");
     107             s.setString(1, "7 days");
     108             ResultSet r = s.executeQuery();

The driver was built from postgresql-jdbc-8.0-311.src using the FreeBSD
port on FreeBSD 5.4 with Java 1.4.2-p7.

Using the older jar built for postgresql-7.3.4 works fine.

Is this syntax no longer supported?

    Nick

--
"The aptly-named morons.org is an obscenity-laced screed..."
     -- Robert P. Lockwood, Catholic League director of research
Nick Johnson, version 2.1                             http://web.morons.org/

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Kris Jurka
Дата:
Сообщение: Re: Missing functionality in ResultSetMetaData ?
Следующее
От: Kris Jurka
Дата:
Сообщение: Re: 8.0.3 parse errors where 7.x was ok