Skip site navigation (1) Skip section navigation (2)

Re: pg_dump and transactions

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 (view raw or flat)
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

In response to

pgsql-patches by date

Next:From: Ian BarwickDate: 2002-03-23 17:43:58
Subject: psql slash command '\G'
Previous:From: Thomas LockhartDate: 2002-03-22 06:01:21
Subject: Re: Where to get official SQL spec (was Re: Domain Support)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group