From: | Ferdinand Smit <ferdinand(at)telegraafnet(dot)nl> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, pgsql-patches(at)postgresql(dot)org |
Subject: | Re: pg_dump and transactions |
Date: | 2002-03-22 16:47:44 |
Message-ID: | 200203221647.g2MGloJ05152@server9.telegraafnet.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-patches |
Hi,
> >> Can you explain the COPY troubles you have had. Seems like a problem.
>
> This is completely unhelpful. Give us a specific case that fails in
> the current release, and we can try to fix it. No, we do not want to
> hear about how you're afraid of COPY because it had bugs in 6.5.
>
Sorry i was in a hurry.
The export-database is PG 7.0.3 in UNICODE.
The export-table is from type text.
The import-database is PG 7.3 in SQL-ASCII.
The problem-records has an euro-sign.
teleportal=# \d uiting
Table "uiting"
Attribute | Type | Modifier
-----------+-----------+-------------------------------------------------
id | integer | not null default nextval('uiting_id_seq'::text)
carrousel | integer | not null
tekst | text |
url | text | not null
start | timestamp |
einde | timestamp |
clicks | integer | not null default 0
views | integer | default 0
otherid | integer |
inarchief | boolean |
Index: uiting_pkey
teleportal=# select tekst from uiting where id = 26109;
tekst
-----------------------------------------------------------
Audi TT Coupé 2000, 77.000km 33.850
(1 row)
teleportal=#
The COPY dump gives :
26109 4 Audi TT Coupé 2000, 77.000km~@| 33.850
http://autotelegraaf.nl/GebruiktOpWeg/Speurder/Toon/?id=475739&referrer=etalage
\N 2002-03-26 14:12:00+01 1907 630563 475739 t
The INSERT dump gives:
INSERT INTO "uiting" VALUES (26109,4,'Audi TT Coup\351 2000, 77.000km
\200\24033.850','http://autotelegraaf.nl/GebruiktOpWeg/Speurder/Toon/?id=475739&referrer=etalage',NULL,'2002-03-26
14:12:00+01',1907,630563,475739,'t');
Regards,
Ferdinand
From | Date | Subject | |
---|---|---|---|
Next Message | Ian Barwick | 2002-03-23 17:43:58 | psql slash command '\G' |
Previous Message | Thomas Lockhart | 2002-03-22 06:01:21 | Re: Where to get official SQL spec (was Re: Domain Support) |