Hi Everyone,

I would like to redirect all the tables created by workspace to one schema
in my database named "default". In the same way, I would like to
redirect all tables created by version to another schema in my database
named "version".

I added <param name="tablePrefix" value="default." /> line in my
<DataStore.. definition but I get syntax error.


> 2010-09-10 16:54:49,234 ERROR
> [org.apache.jackrabbit.core.util.db.ConnectionHelper] (main) Failed to
> execute SQL (stacktrace on DEBUG log level)
> org.postgresql.util.PSQLException: ERROR: syntax error at or near "default"
>   Position: 14
>  at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
>  at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
>  at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
>  at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
>

Is there any way where in my persistenceManager, I can defined something
like:
<param name="schemaObjectPrefix" value="default.${wsp.name}._"/> OR
<param name="schemaObjectPrefix" value="default.version_"/>

Thanks and Regards,
Meenakshi