>[Charset iso-8859-1 unsupported, filtering to ASCII...]
>> hello all
>>
>> normaly a UNIQUE PRIMARY KEY is unique but
>> when you use a heritage, you can insert a duplicate key !!!!
>
>I assume you mean inheritance.
>
>Can you send us a little test sample please?
>
>--
hello all
this is the problem:
example:
test=> CREATE TABLE MAN(name char(10) UNIQUE PRIMARY KEY);T
test=> CREATE TABLE PROFESSOR(scool char(20))INHERITS(MAN);
test=> INSERT INTO PROFESSOR(name) VALUES('DAVIS');
INSERT 54424 1
test=> INSERT INTO PROFESSOR(name) VALUES('DAVIS');
INSERT 54425 1