Re: why so many error when I load the data to database from a script which generated by pg_dump.

From: Raymond O'Donnell <rod(at)iol(dot)ie>
To: Yi Zhao <yi(dot)zhao(at)alibaba-inc(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: why so many error when I load the data to database from a script which generated by pg_dump.
Date: 2008-08-02 11:30:57
Message-ID: 48944571.9020100@iol.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)iol(dot)ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Marco Bizzarri 2008-08-02 13:09:40 Re: Advice on implementing counters in postgreSQL
Previous Message Karsten Hilbert 2008-08-02 11:15:34 Re: Is there any reason why "edit PostgreSQL.conf should be on my menu"