| From: | "Stefan Leitich" <stefan(dot)leitich(at)gmx(dot)at> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Can't update table rows!Probably encoding issue? |
| Date: | 2006-07-29 17:39:36 |
| Message-ID: | 20060729173936.57490@gmx.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mario Splivalo | 2006-07-29 18:59:59 | Re: Postgres replication solutions |
| Previous Message | Andy Shellam | 2006-07-29 10:28:47 | Re: Read db files directly |