[requrest] PostgreSQL use schema besides 'public'

Mehr
4 Jahre 6 Monate her #117389 von ellobo
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

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

LimeSurvey Partners
Mehr
4 Jahre 6 Monate her #117394 von Wun
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 schrieb: 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

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Mehr
1 Jahr 7 Monate her #162281 von matarancon
I have the same problem.
Where is the search_path????

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Mehr
1 Jahr 6 Monate her #164469 von DenisChenu
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 .
An error happen ? Before make a new topic : remind the Debug mode .

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Jetzt loslegen!

Melden Sie sich jetzt an, und erstellen Sie in wenigen Minuten Ihre erste Umfrage.

Account einrichten

Abonnieren Sie unseren Newsletter

Abonnieren Sie unseren Newsletter für alle Neuigkeiten rund um LimeSurvey
captcha