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

Re: [GENERAL] Still big problems with pg_dump!

From: Wim <wdh(at)belbone(dot)be>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Andrew Sullivan <andrew(at)libertyrms(dot)info>,pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Still big problems with pg_dump!
Date: 2002-09-19 05:57:31
Message-ID: 3D89674B.3060306@belbone.be (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-generalpgsql-hackerspgsql-novice

Tom Lane wrote:

>Wim <wdh(at)belbone(dot)be> writes:
>
>>>Hm.  Are you running in a multibyte character encoding?  I had a note
>>>that make_greater_string may have problems in the MULTIBYTE case.
>>>
>
>>Yes, I compiled postgres with multibyte and ODBC support .
>>
>
>But are you actually *using* the multibyte code?  What does "psql -l"
>show as the encoding for your database?
>
>			regards, tom lane
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/users-lounge/docs/faq.html
>
>
>
psql -l shows:

          List of databases
     Name      |  Owner   | Encoding
---------------+----------+-----------
 addressIP     | postgres | SQL_ASCII
 belbonedb_v2  | postgres | SQL_ASCII
 belbonedb_v21 | postgres | SQL_ASCII
 peering       | postgres | SQL_ASCII
 peering_v2    | postgres | SQL_ASCII
 postgres      | postgres | SQL_ASCII
 smsbilling    | postgres | SQL_ASCII
 template0     | postgres | SQL_ASCII
 template1     | postgres | SQL_ASCII
(9 rows)

Maybe I should recompile Postgres without multibyte support...


Cheers!

Wim




In response to

pgsql-novice by date

Next:From: Ciprian PopoviciDate: 2002-09-19 09:01:46
Subject: restricting similar rows
Previous:From: Charles AlbrechtDate: 2002-09-18 23:09:27
Subject: Re: 7.2.2 java configure problem on Mac OS X 10.1.5

pgsql-hackers by date

Next:From: Christopher Kings-LynneDate: 2002-09-19 07:16:36
Subject: Postgres 7.2.2 Segment Error
Previous:From: Tatsuo IshiiDate: 2002-09-19 05:57:12
Subject: Re: Inconsistent Conversion Names

pgsql-admin by date

Next:From: Mark WongDate: 2002-09-19 19:35:05
Subject: Re: Other benchmark than OSDB
Previous:From: Klaus SonnenleiterDate: 2002-09-19 02:40:36
Subject: Re: An Oracle opnion

pgsql-general by date

Next:From: Jean-Christian ImbeaultDate: 2002-09-19 07:49:11
Subject: Re: IN vs EXIIST
Previous:From: Marc G. FournierDate: 2002-09-19 04:55:24
Subject: Re: [HACKERS] PGXLOG variable worthwhile?

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