Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> writes:
> It would make sense to ignore some alter/drop errors in pg_restore.
For the most part I think pg_restore should ignore *all* SQL errors and
try to keep plugging. This would more nearly emulate the behavior of
pg_dump SQL scripts, which is the older and better-tested means of
restoring stuff. There's no downside that I can see --- if the restored
database is too screwed up to use, you can drop it and try again.
This issue has been on the radar screen for awhile, but no one has
gotten around to making it happen...
regards, tom lane