Re: Problems upgrading from 7.1.3

Geoffrey Wossum <geoffrey@pager.net> writes:
> On Wednesday 05 February 2003 01:12 pm, Tom Lane wrote:
>> This smells to me like it could be a newline-formatting problem (COPY is
>> pretty picky about its newlines).

> [ Nope ]

Drat, another perfectly good theory down the drain.

> Bjoern suggested I add "-d" or "-D" to the pg_dump/pg_dumpall command line,
> which worked flawlessly, although recreating the database was a bit slow.

Hm.  The -d business used to be a standard workaround for some known
limitations of COPY, but I was of the opinion that we'd fixed the last
of them as of 7.3.  If you found -d necessary even with 7.3.x pg_dump
then I'd like to see the details.  The table definition (as dumped by
pg_dump) and the first few lines of COPY data from the dump would be
useful info to start with...

            regards, tom lane