Обсуждение: Foreign Keys Question
First of all, hi. I'm new to this mailing list. I searched this on the net, but I didn't get any usable answers... So here's my problem: I have 2 schemas. One is called SITE, one SITE_forum. What I wanted, is to separate the forum from the whole Site db, so I can put them on different servers if I encounter performance problems or anything. So I started the SITE_forum schema, made all my tables, and realized, that I don't want to create the table users in the schema SITE_forum, because I want to use the exact same users than in the schema SITE. One possibility would be, to create 2 identic tables on both schemas, but that really really is not what I'd like to do. So I thought I could make a foreign key on a different Schema (db), and use the same table.... And well, thats where I started to search if this is possible ... and, in fact my main question is: Is this a good idea? I have no idea if this will be fast enough, or if I will have lots of problems afterward.... Could anyone help me with this ? Thanks in advance, Matthias Loitsch -- THEK Matthias Loitsch www.studiothek.com/
Вложения
On Wed, Apr 13, 2005 at 13:54:05 +0200, Matthias Loitsch <m@tthias.com> wrote: > > So I thought I could make a foreign key on a different Schema (db), and > use the same table.... > > And well, thats where I started to search if this is possible ... and, > in fact my main question is: Is this a good idea? > I have no idea if this will be fast enough, or if I will have lots of > problems afterward.... > > Could anyone help me with this ? Schemas are just a name space, so using foreign keys accross schemas shouldn't be a problem. However, it you later put the contents of the schema on other server or even in another database, then you are going to need to make a copy of the data as you can't make foreign key references outside of the current database.
Will inherits helps you ? create table SITE_forum.t1 () inherits (SITE.t); Oleg On Wed, 13 Apr 2005, Matthias Loitsch wrote: > > First of all, hi. I'm new to this mailing list. > > > I searched this on the net, but I didn't get any usable answers... > > > So here's my problem: > > I have 2 schemas. One is called SITE, one SITE_forum. > > What I wanted, is to separate the forum from the whole Site db, so I can > put them on different servers if I encounter performance problems or > anything. > So I started the SITE_forum schema, made all my tables, and realized, > that I don't want to create the table users in the schema SITE_forum, > because I want to use the exact same users than in the schema SITE. > > One possibility would be, to create 2 identic tables on both schemas, > but that really really is not what I'd like to do. > > So I thought I could make a foreign key on a different Schema (db), and > use the same table.... > > And well, thats where I started to search if this is possible ... and, > in fact my main question is: Is this a good idea? > I have no idea if this will be fast enough, or if I will have lots of > problems afterward.... > > Could anyone help me with this ? > > > Thanks in advance, > Matthias Loitsch > > > > Regards, Oleg _____________________________________________________________ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83