2012/9/7 Merlin Moncure
> On Thu, Sep 6, 2012 at 10:12 PM, Edson Richter
> wrote:
> > Em 06/09/2012 15:40, John R Pierce escreveu:
> >
> >> On 09/06/12 5:30 AM, Edson Richter wrote:
>
> You could change the default setting for the user with
>
> ALTER ROLE someuser SET search_
On Thu, Sep 6, 2012 at 10:12 PM, Edson Richter wrote:
> Em 06/09/2012 15:40, John R Pierce escreveu:
>
>> On 09/06/12 5:30 AM, Edson Richter wrote:
You could change the default setting for the user with
ALTER ROLE someuser SET search_path=...
>>>
>>> That is perfect! I can have
Em 06/09/2012 15:40, John R Pierce escreveu:
On 09/06/12 5:30 AM, Edson Richter wrote:
You could change the default setting for the user with
ALTER ROLE someuser SET search_path=...
That is perfect! I can have separate users for each application, and
then they will have the correct search path
On 09/06/12 5:30 AM, Edson Richter wrote:
You could change the default setting for the user with
ALTER ROLE someuser SET search_path=...
That is perfect! I can have separate users for each application, and
then they will have the correct search path.
You saved my day,
the default search_path
Em 06/09/2012 09:21, Albe Laurenz escreveu:
Edson Richter wrote:
2) Is there a way to specify the default schema in JDBC url
(or command I can issue to change
the default schema at runtime, like "set path...")?
SET search_path=schema1,schema2,public;
Problem is that my application uses JDBC an
Edson Richter wrote:
>>> 2) Is there a way to specify the default schema in JDBC url
>>> (or command I can issue to change
>>> the default schema at runtime, like "set path...")?
>> SET search_path=schema1,schema2,public;
> Problem is that my application uses JDBC and Connection Pooling. After
a
Em 06/09/2012 05:12, Albe Laurenz escreveu:
Edson Richter wrote:
That's what I want to do know: I would like to consolidate these 4
separate databases in 1
database with 5 schemas:
- Main schema: will have all shared tables, that will be
read only most of time;
- Schema1 to Schema4: will h
Edson Richter wrote:
> That's what I want to do know: I would like to consolidate these 4
separate databases in 1
> database with 5 schemas:
>
> - Main schema: will have all shared tables, that will be
> read only most of time;
> - Schema1 to Schema4: will have their own tables, read write.
>
>
Em 05/09/2012 15:30, Edson Richter escreveu:
Dear list,
_*Scenario:*_
I'm using PostgreSQL 9.1 on Linux x64 running over CentOS 5.
Everything is fine, but now I do have 4 separate databases running on
different servers, and every server has some shared tables.
I've been working on a complex
