[
https://issues.apache.org/jira/browse/JCR-889?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12506207
]
Alexander Klimetschek commented on JCR-889:
-------------------------------------------
We have used that with Jackrabbit 1.3 and a PostgeSQL 8.2 and can confirm that
it works, using the PM for workspaces and versions.
As Postgres 8.2 has useful new features, we improved the implementation and
schema for 8.2. It has another index and the new 8.2 "RETURNING" feature, that
allows to reduce the 2 statements going through the index to 1.
The two changes are a different schema and a different PostgreSQLNameIndex
class. The PostgreSQLPersistenceManager class needs no changes.
> Add bundle support for PostgreSQL
> ---------------------------------
>
> Key: JCR-889
> URL: https://issues.apache.org/jira/browse/JCR-889
> Project: Jackrabbit
> Issue Type: New Feature
> Components: core
> Reporter: Miguel Angel Jiménez Sampedro
> Assignee: Jukka Zitting
> Priority: Minor
> Fix For: 1.4
>
> Attachments: postgresql.ddl, postgresql.ddl,
> PostgreSQLNameIndex.java, PostgreSQLPersistenceManager.java
>
>
> The class DbNameIndex does not work with this RDBMS since the
> RETURN_GENERATED_KEYS JDBC feature is not implemented in current PostgreSQL
> drivers.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
