Re: [SQL] Question on Inheritance and Primary Keys. - Mailing list pgsql-sql

If I redeclare the Values again, will it overwrite the inherited values?

Thanks for the clarification.
-Dutt

At 09:21 PM 10/11/99 -0400, Tom Lane wrote:
>Dutt Kalapatapu <dutt@eudoramail.com> writes:
>> 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.
>
>Constraints and indexes aren't inherited; you have to redeclare them for
>each derived table.  I agree this is a bug, or at least lack of a
>feature that ought to be there.  It's on the TODO list, in fact:
>
>* Unique index on base column not honored on inserts from inherited table
>  INSERT INTO inherit_table (unique_index_col) VALUES (dup) should fail
>  [inherit] 
>
>I don't know when it might get fixed.  None of the currently active
>developers seem to be very interested in inheritance issues, so it
>could be a while before anyone decides to look at this problem.
>
>            regards, tom lane
>
--Dutt Kalapatapu   ________________________  |ipVerse Inc.,           |  |1901 Landings Drive     |  |Mountain View,
CA-94043|  |Telefono: 650 919 0647  |  |________________________|