Re: Problem with restoring dump (may be tsearch-related)

Hi!

No, I didn't - the DB is quite large, so it's crucial that dump has got
acceptable speed - which it hasn't got when using --inserts; as I found
out it seems to be a matter of sequence of the created objects in the
dump, anyway, so that wouldn't have helped, I think. As far as I can
see, dump always writes the table-definitions _before_ the
customs-datatype-definitions. Which is causing trouble, because the
statements for creating tables that use custom datatypes like txtidx
thus result in an error but not in a table. So when the COPY-statement
follows, which should fill the table, it finds nothing to fill - and
that causes all these errors.

Regards,

Markus

> -----Ursprungliche Nachricht-----
> Von: Oleg Bartunov [mailto:oleg(at)sai(dot)msu(dot)su]
> Gesendet: Donnerstag, 5. September 2002 20:02
> An: Markus Wollny
> Cc: Tom Lane; pgsql-general(at)postgresql(dot)org
> Betreff: Re: [GENERAL] Problem with restoring dump (may be
> tsearch-related)
>
>
> Markus, did you try dump with --inserts option ?
>