Re: Problem with COPY command on pg_dump

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: Blake McBride <blake(at)mcbride(dot)name>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Problem with COPY command on pg_dump
Date: 2017-12-09 15:53:58
Message-ID: 93532B21-1F53-424D-954E-1096C2852C12@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On Dec 9, 2017, at 8:42 AM, Blake McBride <blake(at)mcbride(dot)name> wrote:
>
> Greetings,
>
> I am using pg_dump on version 9.5.10 and trying to import it on version 9.3.20. Many (or all) COPY commands are failing with messages like:
>
> psql:16504.db:16874: ERROR: missing data for column "street"
> CONTEXT: COPY address, line 1: ""
>
> Is there an easy way for me to fix this (like export with some compatibility flag)?
>
> Thanks!
>
> Blake McBride

>
Is there in fact ‘street’ data in the file? Sounds like you have the wrong number of columns. Do you have your actual dump and restore commands to show here?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dale Seaburg 2017-12-09 16:11:42 Windows XP to Win 10 migration issue
Previous Message Blake McBride 2017-12-09 15:42:03 Problem with COPY command on pg_dump