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
Re: 8.0.3 parse errors where 7.x was ok |
Список | 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 по дате отправления: