Creation of Redundant Tables.

From: "Israel Calderon" <icalderus(at)hotmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Creation of Redundant Tables.
Date: 2003-05-27 01:32:08
Message-ID: Sea2-F18Ie8tlMazUSx00026f61@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello ,

I am a novice to the postgres world but am currently assisting with giving a
quick look over of a proposed db schema. I noticed something which seems
rather odd to me within the schema itself. Table A is created with its set
columns and data types, etc. Then I see Table B being created via the
following statement:

CREATE TABLE B ( ) INHERITS (A));

I dont see the sense in having two tables with identical columns yet a
different name. Will this violate any constraints within potgres 7.3.2? Or
is this ok within the rules?

Thanks

Israel

_________________________________________________________________
Add photos to your e-mail with MSN 8. Get 2 months FREE*.
http://join.msn.com/?page=features/featuredemail

Browse pgsql-novice by date

  From Date Subject
Next Message Kassel Ben S CRBE 2003-05-27 02:25:43 Re: [PHP] Case Insensitive Searching?
Previous Message Josh Berkus 2003-05-26 23:40:57 Re: Functions or Rules and Views?