- Posts: 1
- Thank you received: 0
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
[requrest] PostgreSQL use schema besides 'public'
- ellobo
- Topic Author
- Offline
- New Member
Less
More
9 years 3 months ago - 2 years 10 months ago #117389
by ellobo
[Request] PostgreSQL use schema besides 'public' was created by ellobo
Hi!
I'm using a shared postgres database and the admin gave me a non-privileges user with:
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
Last edit: 2 years 10 months ago by c_schmitz.
The topic has been locked.
- Wun
- Offline
- New Member
Less
More
- Posts: 1
- Thank you received: 0
9 years 3 months ago #117394
by Wun
Replied by Wun on 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
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
The topic has been locked.
- matarancon
- Offline
- New Member
Less
More
- Posts: 8
- Thank you received: 2
6 years 4 months ago #162281
by matarancon
Replied by matarancon on topic [requrest] PostgreSQL use schema besides 'public'
I have the same problem.
Where is the search_path????
Where is the search_path????
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13716
- Thank you received: 2502
6 years 2 months ago #164469
by DenisChenu
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Replied by DenisChenu on 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
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 , plugin development .
I don't answer to private message.
The topic has been locked.
- c_schmitz
- Offline
- LimeSurvey GmbH Employee
Less
More
- Posts: 310
- Thank you received: 89
2 years 10 months ago #217542
by c_schmitz
Best regards
Carsten Schmitz
LimeSurvey project leader
Replied by c_schmitz on topic [requrest] PostgreSQL use schema besides 'public'
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>;"
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>;"
Best regards
Carsten Schmitz
LimeSurvey project leader
The topic has been locked.
- holch
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 11712
- Thank you received: 2756
2 years 5 months ago #222646
by holch
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
Replied by holch on topic [requrest] PostgreSQL use schema besides 'public'
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.
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
The following user(s) said Thank You: DenisChenu
The topic has been locked.