Add pg_dump support for ALTER obj DEPENDS ON EXTENSION
Alvaro Herrera <alvherre@alvh.no-ip.org>
Add pg_dump support for ALTER obj DEPENDS ON EXTENSION pg_dump is oblivious to this kind of dependency, so they're lost on dump/restores (and pg_upgrade). Have pg_dump emit ALTER lines so that they're preserved. Add some pg_dump tests for the whole thing, also. Reviewed-by: Tom Lane (offlist) Reviewed-by: Ibrar Ahmed Reviewed-by: Ahsan Hadi (who also reviewed commit 899a04f5ed61) Discussion: https://postgr.es/m/20200217225333.GA30974@alvherre.pgsql
Files
| Path | Change | +/− |
|---|---|---|
| src/bin/pg_dump/common.c | modified | +1 −0 |
| src/bin/pg_dump/pg_dump.c | modified | +99 −8 |
| src/bin/pg_dump/pg_dump.h | modified | +1 −0 |
| src/test/modules/test_pg_dump/t/001_base.pl | modified | +32 −0 |
Discussion
- more ALTER .. DEPENDS ON EXTENSION fixes 17 messages · 2020-02-17 → 2020-04-20