Re: Multi column foreign keys

[prev] [thread] [next] [Date index for 2004/09/03]

--GvXjxJ+pjyke8COw
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Thu, Sep 02, 2004 at 10:19:13 -0500, Y00R0B0T wrote:
> Hello... I'm wondering if anyone on this list had to deal with
> multi-column foreign keys and if so, how'd it go?  Did you create your
> own relationship type (ie Class::DBI::Relationship) or did you find a
> work around within standard CDBI?

Due to the limitation of what is considered the ID of a row, it's
hard to do that.

I think refactoring a bit, so that keys are objects that can span
several columns, and all relationships are built with keys, not
columns, would work. But it breaks backwards compatibility (for when
you ask about relationship data), unless you're really cunning.

--=20
 ()  Yuval Kogman <nothingmuch@xxxxxxxx.xxx> 0xEBD27418  perl hacker &
 /\  kung foo master: /me does a karate-chop-flip: neeyah!!!!!!!!!!!!!!


--GvXjxJ+pjyke8COw
Content-Type: application/pgp-signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQFBODd4VCwRwOvSdBgRAkl1AJ4lSxK2znGNSGn7TPQQp8Sh1rLyzQCgpMm3
udlm8Ojo9wpwbtkVsehE6vk=
=UXYW
-----END PGP SIGNATURE-----

--GvXjxJ+pjyke8COw--