pgsql: Mark index-constraint comments with correct dependency in pg_dum

Mark index-constraint comments with correct dependency in pg_dump.

When there's a comment on an index that was created with UNIQUE or PRIMARY
KEY constraint syntax, we need to label the comment as depending on the
constraint not the index, since only the constraint object actually appears
in the dump.  This incorrect dependency can lead to parallel pg_restore
trying to restore the comment before the index has been created, per bug
#8257 from Lloyd Albin.

This patch fixes pg_dump to produce the right dependency in dumps made
in the future.  Usually we also try to hack pg_restore to work around
bogus dependencies, so that existing (wrong) dumps can still be restored in
parallel mode; but that doesn't seem practical here since there's no easy
way to relate the constraint dump entry to the comment after the fact.

Andres Freund

Branch
------
REL8_4_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/17abf275f070d17fbb8d8dff8f62373e2c6bf9fd

Modified Files
--------------
src/bin/pg_dump/pg_dump.c |   11 ++++++++---
1 file changed, 8 insertions(+), 3 deletions(-)