| From: | "Jaime Casanova" <systemguards(at)gmail(dot)com> |
|---|---|
| To: | "Jonathan Vallar" <bamvallar(dot)db(at)gmail(dot)com> |
| Cc: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Dumping database using 8.1 or 7.1 |
| Date: | 2006-08-09 00:06:56 |
| Message-ID: | c2d9e70e0608081706k4744213eja6e493910a36c9b9@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> It was a little hassle though because I have to manually remove "\M" from
> the dump file. This is manageable.
>
> I am stucked though with one problem
> psql:si_t2:36: ERROR: missing data for column "remarks"
> CONTEXT: COPY si_t2, line 145: <some data>
>
> Upon checking line 145, there are no weird characters. Upon checking the
> whole dump file, the db dump still containts
>
>
> Sample data:
> "jonathan \"
> " "
>
maybe data was:
"jonathan \N"
and that "\N" means a null value in COPY dialect...
--
regards,
Jaime Casanova
"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning."
Richard Cook
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2006-08-09 01:32:13 | Re: Does DROP TABLE free up disk space immediately? |
| Previous Message | Merlin Moncure | 2006-08-08 23:54:11 | Re: PostgreSQL on RAM Disk / tmpfs |