Re: Schema overlay question - Mailing list pgsql-general

From Hrishikesh Deshmukh
Subject Re: Schema overlay question
Date
Msg-id 829d7fb605090216167339ab7e@mail.gmail.com
Whole thread Raw
In response to Re: Schema overlay question  (Michael Fuhr <mike@fuhr.org>)
Responses Re: Schema overlay question
List 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@fuhr.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

pgsql-general by date:

Previous
From: "Sergey E. Koposov"
Date:
Subject: Re: operators, operator classes, Btree and index usage
Next
From: Michael Fuhr
Date:
Subject: Re: Schema overlay question