| From: | tony <tony(at)tgds(dot)net> |
|---|---|
| To: | John DeSoi <desoi(at)pgedit(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: bad dump |
| Date: | 2006-05-02 14:07:08 |
| Message-ID: | 1146578828.2154.153.camel@hush.localdomain |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Le mardi 02 mai 2006 à 09:26 -0400, John DeSoi a écrit :
> > I am convinced that the dump has issues... looked in the doc and don't
> > seem to be missing anything. I have been dumping and rebuilding for
> > the
> > last 6 years (pg version 7).
>
> I would have concerns about going from a newer version to an older
> version (the other way around is less problematic). But you gave no
> clues about specific errors or the format of the dump you are trying
> to load.
Reading through in a text editor (nedit) rather than with pico or nano
in a terminal the sql colour coding gives me a clue:
- the data contains non escaped ' as in "d'Anjou"
Is this my issue?
Tony
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shoaib Mir | 2006-05-02 14:07:27 | Re: Modifying the encoding of a database |
| Previous Message | Rodrigo Sakai | 2006-05-02 14:03:06 | Modifying the encoding of a database |