RE: [GUSDEV] na_sequence_id isn't the primary key of DoTS.NaSequence?

[Y. T. G. <yg...@pc...>]

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
>