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
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? |