Re: circular REFERENCES

Stephan Szabo sez:
} On Tue, 18 Jun 2002, Gregory Seidman wrote:
}
} > I would like to define two tables:
} >
} > CREATE TABLE Person (
} > id SERIAL not null,
} > -- ...
} > team_membership integer default null REFERENCES Team(id),
} > primary key (id)
} > );
} > CREATE TABLE Person (
} > id SERIAL not null,
} > -- ...
} > captain integer not null REFERENCES Person(id),
} > primary key (uid)
} > );
} >
} > Of course, I can't define them that way. Is there any better way to take
} > care of this than to leave out the REFERENCES in the first table and add it
} > with ALTER TABLE ADD CONTRAINT after the second table has been defined?
}
} I assume you meant Team on the second create table. Pretty much you will
} need to use alter table to add one of them. In addition, are you sure
} you want those to be immediately checked? Generally when you have a
} recursive structure like that one or both of the constraints is deferred.

Yep, the second table was supposed to be Team. And I do want them both to
be immediately checked. Users will be added with a NULL team, and will be
able to join a team.

--Greg