Re: Problem with COPY command on pg_dump

2017-12-09 Thread Blake McBride
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

Re: Problem with COPY command on pg_dump

2017-12-09 Thread Tom Lane
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

Re: Problem with COPY command on pg_dump

2017-12-09 Thread Rob Sargent
> 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:

Problem with COPY command on pg_dump

2017-12-09 Thread Blake McBride
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