On Fri, 2011-07-15 at 10:49 +0100, Keith Hatton wrote: > Hi all, > > > > I'm trying to create a new Jena model in a PostgreSQL database. > > I believe I've done this before on other databases successfully, but now I > am getting the problem below. > > I'm using Jena 2.6.4.
The RDB subsystem has been deprecated for new usage for sometime. You would be better off switching to SDB http://openjena.org/wiki/SDB Though I have no evidence it would handle permissions differently. > One thing that may be unusual is that all permissions have been revoked from > the PUBLIC schema, but the user has permissions to create new tables in > their own schema, so I would expect jena_sys_stmt etc to be created in the > user's schema instead. The error does suggest a permissions problem. The SQL commands that will be used are in $JENA/etc/postgresql.sql. As you can see they are simple CREATE TABLE calls. Make sure your user can create/drop those tables. Dave
