> We've talked about stuff like that in the past, but we seem to generally > get stuck about how to specify it. If we add it to the alter table add as > an option then we're generating statements that are almost like a standard > sql statement, but not quite, and some people didn't like that. A set > option that only affected ALTER TABLE ADD CONSTRAINT wouldn't be too bad, > but I'd be worried about making it apply to the normal checks as well > (which I believe was suggested last time this came up). In any case, > making the full checks faster for when you really do care isn't a bad > plan. :)
Or, this: 1. Add the FK to the table BEFORE COPYing data 2. Use the old update blah set reltriggers = 0 trick 3. restore the data 4. Undo step 2 Chris ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
