The underlying imp table, Dots.NaSequenceImp, has a primary key
constraint on na_sequence_id
Run this query:
SELECT table_name, column_name, position
FROM all_cons_columns
WHERE constraint_name = 'PK_NASEQUENCEIMP'
AND owner = 'DOTS';
... and you get this:
NASEQUENCEIMP NA_SEQUENCE_ID 1
-Thomas
> -----Original Message-----
> From: gus...@li...
> [mailto:gus...@li...] On Behalf
> Of Aaron J. Mackey
> Sent: Thursday, November 17, 2005 4:10 PM
> To: Gusdev gusdev-gusdev
> Subject: [GUSDEV] na_sequence_id isn't the primary key of
> DoTS.NaSequence?
>
>
> FOREIGN KEY (a_na_sequence_id) REFERENCES DoTS.NaSequence
> (na_sequence_id),
>
> * ERROR at line 22:
> ORA-02270: no matching unique or primary key for this column-list
>
>
> Does NASequence have a composite primary key with (na_sequence_id,
> version) ? How then do NAfeature's enforce constraints without
> including version?
>
> -Aaron
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by the JBoss Inc. Get
> Certified Today Register for a JBoss Training Course. Free
> Certification Exam for All Training Attendees Through End of
> 2005. For more info visit:
> http://ads.osdn.com/?ad_id=7628&alloc_id=16845&op=click
>
> _______________________________________________
> Gusdev-gusdev mailing list
> Gus...@li...
> https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
>
|
