Re: Anyone working on pg_dump dependency ordering?
От | Rod Taylor |
---|---|
Тема | Re: Anyone working on pg_dump dependency ordering? |
Дата | |
Msg-id | 1069539647.16912.124.camel@jester обсуждение исходный текст |
Ответ на | Re: Anyone working on pg_dump dependency ordering? (Andreas Pflug <pgadmin@pse-consulting.de>) |
Ответы |
Re: Anyone working on pg_dump dependency ordering?
|
Список | pgsql-hackers |
On Sat, 2003-11-22 at 16:53, Andreas Pflug wrote: > Stephan Szabo wrote: > > >You're going to potentially have the constraints scattered in any case due > >to circular dependency chains. I'd think that having all the constraints > >in one place would be easier than trying to go through the list of tables > >that might be in a circular chain in order to find the constraints. > > > > > I still disagree. cyclic dependencies should be avoided anyhow. You'll > get an awful lot of trouble loading data in such a case. Some database > systems refuse to create such stuff right away (mssql). CREATE TABLE a (col integer primary key); CREATE TABLE b (col integer primary key); ALTER TABLE a ADD FOREIGN KEY (col) REFERENCES b INITIALLY DEFERRED; ALTER TABLE b ADD FOREIGN KEY (col) REFERENCES a; How does MSSQL deal with the above?
В списке pgsql-hackers по дате отправления: