From: | Dutt Kalapatapu <dutt(at)eudoramail(dot)com> |
---|---|
To: | pgsql-interfaces(at)postgreSQL(dot)org |
Cc: | pgsql-sql(at)postgreSQL(dot)org, dutt(at)pacbell(dot)net |
Subject: | Question on Inheritance and Primary Keys. |
Date: | 1999-10-11 19:26:38 |
Message-ID: | 3.0.6.32.19991011122638.009aa3e0@pop.eudoramail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces pgsql-sql |
I have two Tables:
TableA(
parameterone int,
parametertwo int,
PRIMARYKEY(parameterone),
UNIQUE(parameterone)
);
TableB(
parameterthree int
)INHERITS(TableA);
I expect from this that when we insert some thing in TableB then
parameterone should be unique, but the database is not enforcing the rule
and it takes duplicate values. But when I insert two duplicate keys in
TableA then it complains. This means that Inheritance removes the
primarykey etc from the inherited table??? I couldn't think why this object
oriented behaviour doesn't work here.
Can some one explain this behaviour.
Thanks
Dutt
--Dutt Kalapatapu
________________________
|ipVerse Inc., |
|1901 Landings Drive |
|Mountain View, CA-94043 |
|Telefono: 650 919 0647 |
|________________________|
From | Date | Subject | |
---|---|---|---|
Next Message | Sergio A. Kessler | 1999-10-11 20:31:36 | Re: [HACKERS] Re: [INTERFACES] Next release is 7.0(?) |
Previous Message | Lamar Owen | 1999-10-11 18:32:26 | Re: [HACKERS] Next release is 7.0(?) |
From | Date | Subject | |
---|---|---|---|
Next Message | Saltsgaver, Scott | 1999-10-11 20:20:55 | Reporting errors when a rule fails. |
Previous Message | Bruce Momjian | 1999-10-11 19:17:14 | Re: [SQL] DELETE/DROP and inheritance |