Re: Complex database infrastructure - how to?
| От | Misa Simic |
|---|---|
| Тема | Re: Complex database infrastructure - how to? |
| Дата | |
| Msg-id | CAH3i69k47HWA0NOTgZDz1HndjpKRha03fuRbQcyOLe6rqwFO_w@mail.gmail.com обсуждение исходный текст |
| Ответ на | Complex database infrastructure - how to? (Edson Richter <edsonrichter@hotmail.com>) |
| Ответы |
Re: Complex database infrastructure - how to?
|
| Список | pgsql-general |
Hi Edson,
Maybe the best option is what Jack has already suggested, to have all in 1 DB in separate schemas (if tables are not already organised in separated schemas...)... But I am not sure I understand well problems:
2012/6/30 Edson Richter <edsonrichter@hotmail.com>
1) Copy tables from Administrative to Application: this approach would work, but I have trouble with the foreign keys. I'll have to disable (or drop) them, then copy data, then activate (or recreate them again). Could lead to problems?
2) dblink: I can't use foreign key to foreign tables. Also, it is very hard to implement with JPA.
1) I guess data just need to be coppied in proper order... though, Postgres have deffered constraint feature, what means, FK will not break transaction until end (all trans commited) - untill all data copied...
2) I just wonder On what way it is possible in MS SQL Server or any other db engine? (to have FK to foreign table... )
Thanks,
Misa
В списке pgsql-general по дате отправления: