The following bug has been logged online: Bug reference: 2120 Logged by: Sagi Bashari Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.1 Operating system: Debian Sarge Description: Crash when doing UTF8<->ISO_8859_8 encoding conversion Details:
Postgresql crashes when a client with ISO_8859_8 encoding tries to select data from a utf8 database. I have compiled postgresql 8.1.1 from scratch with the following commands: ./configure --prefix=/home/sagi/temp/pgtest --enable-debug make make install mkdir /home/sagi/temp/pgtest/data /home/sagi/temp/pgtest/bin/initdb -D /home/sagi/temp/pgtest/data/ /home/sagi/temp/pgtest/bin/postmaster -D /home/sagi/temp/pgtest/data Created a utf8 database: ./createdb test -E utf8 And ran 'SET client_encoding = 'ISO_8859_8'; SELECT 'ש×××';' inside `psql test`. That's ISO_8859_8 hebrew text inside the SELECT. Here's a file containing the query (incase the mail breaks it): http://future.adamnet.co.il/~sagi/temp/enc.sql Psql returned the following message: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. The database log: LOG: server process (PID 1290) was terminated by signal 11 Backtrace: Core was generated by `postgres: sagi test [local] idle '. Program terminated with signal 11, Segmentation fault. #0 0x0823a1a6 in compare2 () #1 0x40100b52 in bsearch () from /lib/libc.so.6 #2 0x0823a41c in LocalToUtf () #3 0x40df8909 in iso8859_to_utf8 () from /home/sagi/temp/pgtest/lib/postgresql/utf8_and_iso8859.so #4 0x08233112 in FunctionCall5 () #5 0x0823adc8 in perform_default_encoding_conversion () #6 0x0823acd3 in pg_client_to_server () #7 0x081508d4 in pq_getmsgstring () #8 0x081b924e in PostgresMain () #9 0x08191b1c in BackendRun () #10 0x08191565 in BackendStartup () #11 0x0818f7c1 in ServerLoop () #12 0x0818eb5a in PostmasterMain () #13 0x08150e0e in main () ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
