Re: BUG #3682: Incomplete database restore

"Heikki Linnakangas" <heikki@enterprisedb.com> writes:
> Perhaps we should include the functionality of that script in pg_dump.

I'm pretty uncomfortable with the notion of having pg_dump deliberately
throw data away.  Another problem is that even if we did that, it would
only help people who dumped their old DB with 8.3 pg_dump.

Having the functionality in pg_restore would be a little saner, but it
still seems like a big wart.

As for the datatype issue, I wonder whether we should just advise people
to do
    CREATE DOMAIN public.tsvector AS pg_catalog.tsvector;
before restoring?

            regards, tom lane