Re: [CDBI] Sequences with multiple primary keys
Andrew Gianni <agianni-LjRBWs/[email protected]>
| Newsgroups | gmane.comp.lang.perl.modules.class-dbi |
|---|---|
| Message-ID | <C0B843ED.16830%[email protected]> |
On 6/16/06 11:11 AM, "Perrin Harkins" <[email protected]> wrote: > 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? Ask our database architect, I can't pretend to understand either, but it's what I have to work with :P Andrew