Hi!

I'm using a shared postgres database and the admin gave me a non-privileges user with:

Hello,

new to this forum, I second that

I have modified create-pgsql.sql and CPgsqlSchema.php to make it work,
but it seems not to be so simple.

Did somebody get this scenario to work ?

Regards Wun

ellobo wrote: Hi!

I'm using a shared postgres database and the admin gave me a non-privileges user with:

Code:

search_path=limesurvey, public

This means all the tables created by my user end up in the 'limesurvey' schema.

I'm unable to install limesurvey in a specific schema. This is an important feature in postgresql because most of the time you're not given an entire database.

Thanks in advance,
Regards,
LL

I have the same problem.
Where is the search_path????

Dis someone put this on Bug report or feature request ?

Forum are not the place for this, to start discussion or know if there are a solution, yes. But not for asking the feature …

www.limesurvey.org/community/feature-requests

Here is somewhat of a workaround:

This will work for existing instances, which you moved from 'public' to a new schema.
This does not work for new instances, yet.


To set a custom schema you need to modify the search path by SQL right after establishing connection.


This is possible by adding a initSQL clause to config.php in the DB credentials sections.

( See \application\config\config-sample-sqlsrv.php for an example) .

The related query could be like

"SET search_path TO <name_of_your_accountschema>;"

Just posting here to get rid of the (already deleted) spam message that still shows up in the forum overview. We need to fix the forum software. In the forums with less traffic, those messages show for ever in the preview of the overview page. Not a good image for the forum.