Re: Schema overlay question

From: Hrishikesh Deshmukh <hdeshmuk(at)gmail(dot)com>
To: Michael Fuhr <mike(at)fuhr(dot)org>
Cc: Postgresql-General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Schema overlay question
Date: 2005-09-02 23:16:04
Message-ID: 829d7fb605090216167339ab7e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

HI All,

What i meant was when the third component of tables are ready and i can
create tables any time what happens to relationships when i am building the
third component tables? How smooth the process will be?

Regards,
Hrishi

On 9/2/05, Michael Fuhr <mike(at)fuhr(dot)org> wrote:
>
> On Fri, Sep 02, 2005 at 05:28:11PM -0400, Hrishikesh Deshmukh wrote:
> > We are designing a database, the database has three major components
> (each
> > component with 4-8 tables)
> > two components are ready, is it possible to 'overlay' the third one
> later?
> > or
> > Do i have to drop all the components (along with data!!!) and then add
> the
> > third component and then build the entire DB?
> > What i am saying is some tables are existing, could i later add a bunch
> of
> > tables at a later date without dropping the entire database?
>
> What exactly do you mean by "overlay"? As far as the database is
> concerned, you can create tables any time you want: today, tomorrow,
> or a year from now. Is there some specific case you're concerned
> about? If so then please elaborate.
>
> --
> Michael Fuhr
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2005-09-03 00:41:19 Re: Schema overlay question
Previous Message Sergey E. Koposov 2005-09-02 22:53:22 Re: operators, operator classes, Btree and index usage