X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id AECE39FB2D1 for ; Sat, 29 Jul 2006 14:46:26 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 83486-04 for ; Sat, 29 Jul 2006 14:46:20 -0300 (ADT) X-Greylist: delayed 00:06:38.451869 by SQLgrey- Received: from mail.gmx.net (mail.gmx.de [213.165.64.21]) by postgresql.org (Postfix) with SMTP id 0B5629FB2C6 for ; Sat, 29 Jul 2006 14:46:19 -0300 (ADT) Received: (qmail 27069 invoked by uid 0); 29 Jul 2006 17:39:36 -0000 Received: from 62.47.142.107 by www099.gmx.net with HTTP; Sat, 29 Jul 2006 19:39:36 +0200 (CEST) Content-Type: text/plain; charset="us-ascii" Date: Sat, 29 Jul 2006 19:39:36 +0200 From: "Stefan Leitich" Message-ID: <20060729173936.57490@gmx.net> MIME-Version: 1.0 Subject: Can't update table rows!Probably encoding issue? To: pgsql-admin@postgresql.org X-Authenticated: #1110022 X-Flags: 0001 X-Mailer: WWW-Mail 6100 (Global Message Exchange) X-Priority: 3 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.648 tagged_above=0 required=5 tests=FORGED_RCVD_HELO, PLING_QUERY, SPF_PASS X-Spam-Level: X-Archive-Number: 200607/288 X-Sequence-Number: 22534 Hi! Due to a server upgrade (new machine) i ran into the following problem, can anyone give me a hint? Since porting the database on the new machine I can't update table columns containing a multi-line string (ie. containing a line break). The old system was configured as follows: Postgres 7.3.2 and system wide locale set to 'en_US'. pg.catalog.pg_settings.server_encoding = SQL_ASCII pg.catalog.pg_settings.client_encoding = SQL_ASCII pg.catalog.pg_settings.lc_* = C The new system is configured as follows: Postgres 7.3.15 and system wide locale set to 'de_AT.UTF8'. pg.catalog.pg_settings.client_encoding = SQL_ASCII pg.catalog.pg_settings.client_encoding = SQL_ASCII pg.catalog.pg_settings.lc_* = de_AT The migration between the systems was done by generating a database dump using pg_dump on the old system and pgsql with the dump on the new system. Cheers Stefan