Hello,

I want to get database information using metadata with Spring (1.2.4).
It's OK with postGre8.0, but when I use postGre8.1, error...

what about this function "information_schema._pg_keypositions()" ?

Caused by: org.springframework.jdbc.support.MetaDataAccessExc eption:
Error while extracting DatabaseMetaData; nested exception is
org.postgresql.util.PSQLException: ERROR: function
information_schema._pg_keypositions() does not exist
at
org.springframework.jdbc.support.JdbcUtils.extract DatabaseMetaData(JdbcUtils.java:180)

at
arc.bd.spring.service.TableService.fillRelation1_1 (TableService.java:181)
... 4 more
Caused by: org.postgresql.util.PSQLException: ERROR: function
information_schema._pg_keypositions() does not exist
at
org.postgresql.core.v3.QueryExecutorImpl.receiveEr rorResponse(QueryExecutorImpl.java:1471)

at
org.postgresql.core.v3.QueryExecutorImpl.processRe sults(QueryExecutorImpl.java:1256)

at
org.postgresql.core.v3.QueryExecutorImpl.execute(Q ueryExecutorImpl.java:175)

at
org.postgresql.jdbc2.AbstractJdbc2Statement.execut e(AbstractJdbc2Statement.java:389)

at
org.postgresql.jdbc2.AbstractJdbc2Statement.execut eWithFlags(AbstractJdbc2Statement.java:314)

at
org.postgresql.jdbc2.AbstractJdbc2Statement.execut eQuery(AbstractJdbc2Statement.java:221)

at
org.postgresql.jdbc2.AbstractJdbc2DatabaseMetaData .getImportedExportedKeys(AbstractJdbc2DatabaseMeta Data.java:3237)

at
org.postgresql.jdbc2.AbstractJdbc2DatabaseMetaData .getImportedKeys(AbstractJdbc2DatabaseMetaData.jav a:3533)

at
arc.bd.spring.callback.ImportedKeyInfo.processMeta Data(ImportedKeyInfo.java:28)

at
org.springframework.jdbc.support.JdbcUtils.extract DatabaseMetaData(JdbcUtils.java:174)

... 5 more

--
Il n'y a pas de mauvais langage, il n'y a que des bons programmeurs



---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend