On Thu, 14 Aug 2003, Stephan Szabo wrote: > That really needs to be rewritten to do a single check over the table > rather than running the constraint for every row. I keep meaning to get > around to it and never actually do. :( I'm not sure that in practice > you'll get a better plan at restore time depending on what the default > statistics give you.
Perhaps it would be easier to allow SKIP VALIDATION (or something) with ALTER TABLE ADD .... which can set FkConstraint->skip_validation. If we're just handling pg_dump output, then presumably the data is already validated. On the other handle, it might encourage users to bypass FKs when they feel like it... Thanks, Gavin ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings