[requrest] PostgreSQL use schema besides 'public'

More
3 years 5 months ago #117389 by ellobo
ellobo created the topic: [requrest] PostgreSQL use schema besides 'public'
Hi!

I'm using a shared postgres database and the admin gave me a non-privileges user with:
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

Please Log in or Create an account to join the conversation.

More
3 years 5 months ago #117394 by Wun
Wun replied the topic: [requrest] PostgreSQL use schema besides 'public'
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:

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

Please Log in or Create an account to join the conversation.

More
7 months 1 week ago #162281 by matarancon
matarancon replied the topic: [requrest] PostgreSQL use schema besides 'public'
I have the same problem.
Where is the search_path????

Please Log in or Create an account to join the conversation.

More
5 months 3 weeks ago #164469 by DenisChenu
DenisChenu replied the topic: [requrest] PostgreSQL use schema besides 'public'
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

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .

Please Log in or Create an account to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!