diff options
| author | randomdan <randomdan@localhost> | 2011-01-06 19:37:58 +0000 |
|---|---|---|
| committer | randomdan <randomdan@localhost> | 2011-01-06 19:37:58 +0000 |
| commit | fe0fbc0b6168a730d86c013755a9ee47f300c2be (patch) | |
| tree | 35c5fd2116c4da58edfcea082a205313b0be1950 | |
| parent | Return HTTP 500 on error (diff) | |
| download | gentoobrowse-fe0fbc0b6168a730d86c013755a9ee47f300c2be.tar.bz2 gentoobrowse-fe0fbc0b6168a730d86c013755a9ee47f300c2be.tar.xz gentoobrowse-fe0fbc0b6168a730d86c013755a9ee47f300c2be.zip | |
Specify schema search path
| -rw-r--r-- | gentoobrowse/datasources/postgres-web.xml | 10 | ||||
| -rw-r--r-- | gentoobrowse/datasources/postgres.xml | 10 |
2 files changed, 10 insertions, 10 deletions
diff --git a/gentoobrowse/datasources/postgres-web.xml b/gentoobrowse/datasources/postgres-web.xml index 0825e30..1770c41 100644 --- a/gentoobrowse/datasources/postgres-web.xml +++ b/gentoobrowse/datasources/postgres-web.xml @@ -1,10 +1,10 @@ <?xml version="1.0"?> <project2:rdbmsdatasource xmlns:project2="http://project2.randomdan.homeip.net" name="postgres-web"> <readonly preferlocal="true"> - <dsn host="firebrand">Driver=postgresql;ServerName=firebrand.random.lan;Username=apache;Database=gentoo;Password=gentoo;</dsn> - <dsn host="defiant">Driver=postgresql;ServerName=defiant.random.lan;Username=apache;Database=gentoo;Password=gentoo;</dsn> - <dsn host="akira">Driver=postgresql;ServerName=akira.random.lan;Username=apache;Database=gentoo;Password=gentoo;</dsn> - <dsn host="riogrande">Driver=postgresql;ServerName=riogrande.random.lan;Username=apache;Database=gentoo;Password=gentoo;</dsn> + <dsn host="firebrand">Driver=postgresql;ServerName=firebrand.random.lan;Username=apache;Database=gentoo;Password=gentoo;ConnSettings=SET search_path=gentoobrowse,public;</dsn> + <dsn host="defiant">Driver=postgresql;ServerName=defiant.random.lan;Username=apache;Database=gentoo;Password=gentoo;ConnSettings=SET search_path=gentoobrowse,public;</dsn> + <dsn host="akira">Driver=postgresql;ServerName=akira.random.lan;Username=apache;Database=gentoo;Password=gentoo;ConnSettings=SET search_path=gentoobrowse,public;</dsn> + <dsn host="riogrande">Driver=postgresql;ServerName=riogrande.random.lan;Username=apache;Database=gentoo;Password=gentoo;ConnSettings=SET search_path=gentoobrowse,public;</dsn> </readonly> - <masterdsn>Driver=postgresql;ServerName=postgresql.random.lan;Username=apache;Database=gentoo;Password=gentoo;</masterdsn> + <masterdsn>Driver=postgresql;ServerName=postgresql.random.lan;Username=apache;Database=gentoo;Password=gentoo;ConnSettings=SET search_path=gentoobrowse,public;</masterdsn> </project2:rdbmsdatasource> diff --git a/gentoobrowse/datasources/postgres.xml b/gentoobrowse/datasources/postgres.xml index b48a434..448892a 100644 --- a/gentoobrowse/datasources/postgres.xml +++ b/gentoobrowse/datasources/postgres.xml @@ -1,10 +1,10 @@ <?xml version="1.0"?> <project2:rdbmsdatasource xmlns:project2="http://project2.randomdan.homeip.net" name="postgres"> <readonly preferlocal="true"> - <dsn host="firebrand">Driver=postgresql;ServerName=firebrand.random.lan;Username=gentoo;Database=gentoo;Password=gentoo;</dsn> - <dsn host="defiant">Driver=postgresql;ServerName=defiant.random.lan;Username=gentoo;Database=gentoo;Password=gentoo;</dsn> - <dsn host="akira">Driver=postgresql;ServerName=akira.random.lan;Username=gentoo;Database=gentoo;Password=gentoo;</dsn> - <dsn host="riogrande">Driver=postgresql;ServerName=riogrande.random.lan;Username=gentoo;Database=gentoo;Password=gentoo;</dsn> + <dsn host="firebrand">Driver=postgresql;ServerName=firebrand.random.lan;Username=gentoo;Database=gentoo;Password=gentoo;ConnSettings=SET search_path=gentoobrowse,public;</dsn> + <dsn host="defiant">Driver=postgresql;ServerName=defiant.random.lan;Username=gentoo;Database=gentoo;Password=gentoo;ConnSettings=SET search_path=gentoobrowse,public;</dsn> + <dsn host="akira">Driver=postgresql;ServerName=akira.random.lan;Username=gentoo;Database=gentoo;Password=gentoo;ConnSettings=SET search_path=gentoobrowse,public;</dsn> + <dsn host="riogrande">Driver=postgresql;ServerName=riogrande.random.lan;Username=gentoo;Database=gentoo;Password=gentoo;ConnSettings=SET search_path=gentoobrowse,public;</dsn> </readonly> - <masterdsn>Driver=postgresql;ServerName=postgresql.random.lan;Username=gentoo;Database=gentoo;Password=gentoo;</masterdsn> + <masterdsn>Driver=postgresql;ServerName=postgresql.random.lan;Username=gentoo;Database=gentoo;Password=gentoo;ConnSettings=SET search_path=gentoobrowse,public;</masterdsn> </project2:rdbmsdatasource> |