Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                

Re: app table names - Mailing list pgsql-general

From Vick Khera
Subject Re: app table names
Date
Msg-id 2968dfd61003170704w20b5f7a4l3a846fdb0796cc57@mail.gmail.com
Whole thread Raw
In response to Re: app table names  (Justin Graf <justin@magwerks.com>)
List pgsql-general
On Tue, Mar 16, 2010 at 5:25 PM, Justin Graf <justin@magwerks.com> wrote:
>> Do not mix data from multiple applications in one database. Use
>> multiple databases to isolate them entirely.
>>
>>
> That's not always a practical solution to the problem,
>
> the Apps may need to share numerous tables, duplicating the data and
> keeping it sync can be a pain. Having to open numerous database
> connections to different databases is a resource hog .
>

That was not a consideration in the original post.  In that case, make
your application developers use unique names.

pgsql-general by date:

Previous
From: josep porres
Date:
Subject: db error messages when I try to debug with pgadmin
Next
From: Ian Barwick
Date:
Subject: Re: Unexpected result from selecting an aliased but non-existing column called "name"