A.L.E.C wrote:
> On Fri, 23 Apr 2010 22:06:22 +0200, "Dirk F. Raetzel" wrote:
>
>> pgsql://username:passw...@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/
