| 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: | Whole Thread | Raw Message | 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? |