]> granicus.if.org Git - postgresql/commit
Simplify a couple of pg_dump and psql \d queries about index constraints
authorTom Lane <tgl@sss.pgh.pa.us>
Thu, 11 Mar 2010 04:36:43 +0000 (04:36 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Thu, 11 Mar 2010 04:36:43 +0000 (04:36 +0000)
commite6555b436e44fc43f14b3d8c1f782fbd3924485d
treed25247408f1af6952d2ee97ba38cbe1ad710839a
parent4df5c6c7195cf9382d249d6371d2c8e02d46a7ae
Simplify a couple of pg_dump and psql \d queries about index constraints
by joining to pg_constraint.conindid, instead of the former technique of
joining indirectly through pg_depend.  This is much more straightforward
and probably faster as well.  I had originally desisted from changing these
queries when conindid was added because I was worried about losing
performance, but if we join on conrelid as well as conindid then the index
on conrelid can be used when pg_constraint is large.
src/bin/pg_dump/pg_dump.c
src/bin/psql/describe.c