On Mon, 2005-11-28 at 18:39, Stock, Stuart wrote:
> FYI in case you still have the problem after using pg_dump from 8.1 (we did)
> you may have an encoding mismatch between your 7.3 and 8.1 databases. Our
> 7.x database was SQL_ASCII while 8.1 defaults to creating databases as
> UTF-8. I had simila
Title: AW: [GENERAL] Errors upgrading from 7.3 to 8.1
Hello!
We experienced the exact same problems. You may solve the problem by feeding the dump through iconv. See my earlier message on this issue
http://archives.postgresql.org/pgsql-general/2005-11/msg00799.php
On top of that you'
n Behalf Of Jim Buttafuoco
Sent: Monday, November 28, 2005 4:27 PM
To: [EMAIL PROTECTED]; Postgres General
Subject: Re: [GENERAL] Errors upgrading from 7.3 to 8.1
you should use the 8.1 pg_dump not the 7.3 one.
Give it a try
-- Original Message ---
From: Benjamin Smith <[EM
you should use the 8.1 pg_dump not the 7.3 one.
Give it a try
-- Original Message ---
From: Benjamin Smith <[EMAIL PROTECTED]>
To: Postgres General
Sent: Mon, 28 Nov 2005 16:22:18 -0800
Subject: [GENERAL] Errors upgrading from 7.3 to 8.1
> Currently running Postg
Currently running Postgres 7.3.9 32bit on Fedora Core 1, and upgrading to PG
8.1 64bit on Centos 4.
When I load the file,
psql -U dbname < dbname.sql
I get this error:
ERROR: invalid UTF-8 byte sequence detected near byte 0x96
when inserting fields that seem to contain HTML. What could be c
