Re: Constraint bug?

In article <2b391j$kj5_at_news.cc.oberlin.edu>, bamon_at_OCVAXC.CC.OBERLIN.EDU (Jennifer R. Amon (216) 775-6987) writes:
>Hi,
>
>Either there is something I'm not seeing, or there is a bug in the way
>that primary key constraints are enforced. Any suggestions out there?
>
> SQL> insert into fa035
> 2 select state_code,1994,travel_allowance from fa035;
> insert into fa035
> *
> ERROR at line 1:
> ORA-00001: unique constraint (OBERLIN.FA035_PK) violated
>
>Hmmm. There must already be some 1994 rows.
>

This was my own error. There were already rows for both 1992 and 1993. My insert tried to duplicate both the 1992 and 1993 rows as 1994 rows.

Duh!!

Thanks.

Jennifer R. Amon            PHONE: (216) 775-6987   
Houck Computing Center        FAX: (216) 775-8573    
Oberlin College          
Oberlin, OH 44074        INTERNET: bamon_at_ocvaxc.cc.oberlin.edu
_____________________________________________________________________