Thom Brown <thom@xxxxxxxxx> writes: > Yeah, there's no index on contacts.country, and that would certainly > make the query acceptably quick, but I'm asking whether the > non-indexed scenario is going about things the most efficient way, > given what it has available to it. [ shrug... ] If you're up for nuking the entire existing foreign-key infrastructure and starting over, you could think about doing things some other way. But you're not going to get to anyplace other than "run a query for each deleted row" without a *lot* of work. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
