A.L.E.C wrote:
On Fri, 23 Apr 2010 22:06:22 +0200, "Dirk F. Raetzel" wrote:
pgsql://username:password@localhost/database?schema=ROUNDCUBE
Any idea on how to succeed in logging into the schema?
Try to add schema prefix in all db_table_* and db_sequence_* options.
This is not working, as it won't change the search path vor pgsql.
If you for example do
INSERT INTO myschema.users ...
then implicitly sequence user_ids will be searched to generate a new user_id, but pgsql will not find it, as it only looks in the default search_path (usually 'public'). RC is not explicitly referencing the sequence.
A workaround is to change program/include/rcube_mdb2.php and add in function dsn_connect just before the final return statement:
$dbh->query("SET search_path TO myschema");
Dirk _______________________________________________ List info: http://lists.roundcube.net/users/