[GENERAL] tables, where

[Martín Marqués]

Hi
Is it a bad idea to put tables of different aplications, even if they have 
somethings in comun, in the same database?

Saludos... :-)

-- 
El mejor sistema operativo es aquel que te da de comer.
Cuida tu dieta.
-
Martin Marques  |[EMAIL PROTECTED]
Programador, Administrador  |   Centro de Telematica
   Universidad Nacional
del Litoral
-

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] tables, where

[Richard Huxton]

From: "Martn Marqus" [EMAIL PROTECTED]

 Hi
 Is it a bad idea to put tables of different aplications, even if they have
 somethings in comun, in the same database?

 Saludos... :-)

Plus points :

+ If you need to join between tables you will *need* to do this

Minus points :

- You will need to make sure tables for application aa and bb don't have the
same name (so aa_contacts and bb_contacts)

- Security: make sure each application runs as a different user and only has
access to the tables is is supposed to.

- It is harder to back up individual applications' data

HTH

- Richard Huxton


---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly

Re: [GENERAL] tables, where

[Rich Shepard]

On Thu, 29 Mar 2001, Richard Huxton wrote:

 From: "Martín Marqués" [EMAIL PROTECTED]

  Is it a bad idea to put tables of different aplications, even if they have
  somethings in comun, in the same database?

 Plus points :

 Minus points :

  As I have not received an answer to my posted question of a few days ago,
let me try again, under this thread. It's a related question.

  The docs for the 6.x releases described how to use different data
directories under postgres. After trying unsuccessfully with a number of
different approaches, I asked the list and learned that this feature was
broken under 6.x but was scheduled to be working in the 7.x releases. My
question is whether or not (with 7.0.3 or 7.1) I can specify environment
variables such as $PGDATA2 and $PGDATA3, each pointing to a project-specific
data directory, and be able to have postgres recognize (and accept!) that
directory?

  For example, (and this is what I tried with the 6.5.x series), in
~/.bash_profile I have this:

PGLIB=/usr/lib/pgsql
PGDATA=/var/lib/pgsql
PGDATA2=/home/rshepard/accounting/paisley
export PGLIB PGDATA PGDATA2

  I went through the process of registering PGDATA2 with postgres
(supposedly), but I could not use this directory.

  Could I now do this and have it work?

Thanks,

Rich

Dr. Richard B. Shepard, President

   Applied Ecosystem Services, Inc. (TM)
2404 SW 22nd Street | Troutdale, OR 97060-1247 | U.S.A.
 + 1 503-667-4517 (voice) | + 1 503-667-8863 (fax) | [EMAIL PROTECTED]


---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]