I suppose it's something I'm doing. I'm pg_dump'ing the schema with the
data, so I can't be missing any columns. However, I wrote a program to
filter out certain data. I believe that is where the problem is. I wrote
it a long, long time ago before --exclude-table-data existed. When I
use --exc
Rob Sargent writes:
>> On Dec 9, 2017, at 8:42 AM, Blake McBride wrote:
>> 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
> On Dec 9, 2017, at 8:42 AM, Blake McBride 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:
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 e