From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Jonathan davis <haj(at)idianet(dot)net> |
Cc: | "Pgsql-General(at)Postgresql(dot) Org" <pgsql-general(at)postgreSQL(dot)org> |
Subject: | Re: [GENERAL] just little BUG |
Date: | 1999-07-09 16:38:32 |
Message-ID: | 199907091638.MAA00937@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Yikes, I see what you mean. Added to TODO:
* Unique index on base column not honored on inserts from inherited table
INSERT INTO inherit_table (unique_index_col) VALUES (dup) should fail
> >> 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
--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Mike Engelhart | 1999-07-09 21:18:32 | rules failed |
Previous Message | Roberto Moreda | 1999-07-09 13:51:43 | Transations in postgres |