Thom Brown <t...@linux.com> 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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to