On Thu, 15 Sep 2011, Rich Shepard wrote:
It appears that this error is generated when a row has a missing value in the 'quant' column and the column contains '\N' in the text file. For example, \N GW-22 2005-03-09 Depth to Water \N Feet \N \N \N \N
Something strange is going on here. I moved the above line from row 47363 (within the COPY block) to row 2. This produced this error: ERROR: extra data after last expected column CONTEXT: COPY chemistry, line 2: "\N GW-22 2005-03-09 Depth to Water \N Feet \N \N \N \N" I created a blank line just beneath this one and entered the same data on this new row, ensuring that there are no extra data after column #10. The results are the same: ERROR: extra data after last expected column CONTEXT: COPY chemistry, line 2: "\N GW-22 2005-03-09 Depth to Water \N Feet \N \N \N \N" What could possibly be going on here? This row was not modified by me after running pg_dump on the chemistry table, so why will it not be restored? Totally confused, Rich -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
