Thread: why so many error when I load the data to database from a script which generated by pg_dump.
why so many error when I load the data to database from a script which generated by pg_dump.
From
Yi Zhao
Date:
hi, all:
I have a database to store the information about the html source of the
web page.
I wan't to move the data to another database, so I pg_dump the data to a
file:
/usr/local/pgsql/bin/pg_dump htmldb -Upostgres -p 5433 > /tmp/dump.sql
now, I load the data into new database:
/usr/local/pgsql/bin/psql -d newbd -Upostgres -p 5432 -f /tmp/dump.sql
but, I got some error about the "column error", for example:
----
psql:/export/chry.sql:1965134: ERROR: missing data for column "content"
CONTEXT: COPY htmlcontent, line 312807: "1207327 <!DOCTYPE HTML PUBLIC
"-//W3C//DTD
HTML 4.0 Transitional//EN">\n<html>\n<head>\n<meta http-e..."
----
I don't konw that why I can store it in a database, but I can't dump it
and reload into another one.
how to fix it?
my postgresql version: 8.3.3
thanks,
regards,
Re: why so many error when I load the data to database from a script which generated by pg_dump.
From
Raymond O'Donnell
Date:
On 02/08/2008 07:22, Yi Zhao wrote: > CONTEXT: COPY htmlcontent, line 312807: "1207327 <!DOCTYPE HTML PUBLIC > "-//W3C//DTD > HTML 4.0 Transitional//EN">\n<html>\n<head>\n<meta http-e..." Would there perchance be tabs embedded in the HTML that might confuse COPY? Ray. ------------------------------------------------------------------ Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@iol.ie Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------