Re: [CDBI] Sequences with multiple primary keys

Perrin Harkins <[email protected]>
Newsgroups gmane.comp.lang.perl.modules.class-dbi
Message-ID <[email protected]> 
Andrew Gianni wrote:
> The one-to-many tables off of that table have at least two
> primary keys: the foreign key from the main table as well as a unique id for
> that table, which also comes from a sequence specific to that table.

May I ask why?  I can't see a reason to include the foreign key in this 
table's primary key if it already has a unique ID.  Maybe what you want 
there is a unique constraint instead?

- Perrin
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.