Re: [GENERAL] Multiple foreign keys on same field

2004-12-15 Thread Ciprian Popovici
On Mon, 13 Dec 2004 23:00:45 -0700 Michael Fuhr <[EMAIL PROTECTED]> wrote: > Do you mean that you don't need foreign key constraints to enforce > referential integrity, but only to cascade changes to another table? > If so, have you considered using triggers instead? Or have I > misunderstood what

Re: [GENERAL] Multiple foreign keys on same field

2004-12-13 Thread Michael Fuhr
On Tue, Dec 14, 2004 at 02:06:24AM +0200, Ciprian Popovici wrote: > I'm in a situation where it would be useful to bind a field in a table via > foreign keys to N other tables simultaneously. The table holds a common > type of info which all those other tables use. The many tables refer to the > c

Re: [GENERAL] Multiple foreign keys on same field

2004-12-13 Thread Bruno Wolff III
On Tue, Dec 14, 2004 at 02:06:24 +0200, Ciprian Popovici <[EMAIL PROTECTED]> wrote: > I'm in a situation where it would be useful to bind a field in a table via > foreign keys to N other tables simultaneously. The table holds a common > type of info which all those other tables use. The many tabl