Here is a new version of my patch for allowing pg_dump to DROP schema
Bruce Momjian <bruce@momjian.us>
Here is a new version of my patch for allowing pg_dump to DROP schema elements prior to CREATEing new ones. It is under control of the -c command line option (with the default being status quo). The DROP TRIGGER portion still needs implementation. Anyone able to help clarify what exactly the CREATE TRIGGER portion does so I can fix this? Again, I have tried this with tables/indexes/sequences, but do not have other schema elements in my database. As a result, I am not 100% convinced that I got the syntax correct in all cases (but think I did, nonetheless). If anyone can check the other cases, I'd appreciate it. Cheers, Brook [I added manual page and sgml additions for the new -c option.]
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/ref/pg_dump.sgml | modified | +12 −1 |
| src/bin/pg_dump/pg_dump.c | modified | +81 −2 |
| src/man/pg_dump.1 | modified | +7 −1 |