Re: Re: Class::DBI Intro


Syntactic Confectionery Delight
	PerlMonks

Re: Re: Class::DBI Intro

by salvadors (Pilgrim)

on Aug 01, 2003 at 07:58 UTC ( [id://279880]=note: print w/replies, xml )

Need Help??

in reply to Re: Class::DBI Intro
in thread Class::DBI Intro

(but note that your join table still requires a primary key)

Actually, it doesn't always. As long as the relationship is unique, the cross-reference itself can be treated as a multi-column primary key, even if it isn't defined as such in the database.

Strange things can happen with this if you step off the (admittedly very narrow) beaten path, but for general cross-referencing it seems to work just fine.

Tony

Comment on Re: Re: Class::DBI Intro

Replies are listed 'Best First'.

Re^3: Class::DBI Intro
by mojotoad (Monsignor) on Aug 01, 2003 at 19:06 UTC

Actually, it doesn't always. As long as the relationship is unique, the cross-reference itself can be treated as a multi-column primary key, even if it isn't defined as such in the database.

Can you give an example? I'm still learning about Class::DBI, but thus far I have not found a way to avoid it claiming the first column as a primary key (in the absence of such a declaration in the DB table itself).

Matt

[reply]

In Section Meditations