[horde] Postgresql

lst_hoe02 at kwsoft.de lst_hoe02 at kwsoft.de
Mon Apr 22 11:49:08 UTC 2013


Zitat von Michael M Slusarz <slusarz at horde.org>:

> Quoting Rod K <horde at 23net.net>:
>
>> Sorry if this is documented somewhere.  I searched but of course  
>> the "schema" term turns up talk about DB structure.
>>
>> What I'm interested in learning is if there is an easy way to get  
>> Horde to use a database schema other than the public schema when  
>> using Postgres?  I have an extensive database for managing our  
>> business including email and need to have Horde connect to the same  
>> database as I will be needing to create views that will use some of  
>> the Horde tables AND some of the existing tables.  And also provide  
>> an easy way to clean up user data from Horde when their accounts  
>> are deleted in the rest of the system.
>
> You almost certainly will need to make changes locally to the Horde  
> code the modify the SQL queries.
>
> michael

Another way would be to alter the default schema of the Horde DB-User,  
no? From what i remember creating a schema named as the DB-user and  
owned by this user would set this schema as default for every SQL  
operation not using a schema setting at all.

Regards

Andreas




More information about the horde mailing list