From: | "Andrew Gilligan" <andy(at)tcpd(dot)net> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #3866: Segfault during table update when using convert_from() |
Date: | 2008-01-09 22:37:57 |
Message-ID: | 200801092237.m09Mbvrq085876@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 3866
Logged by: Andrew Gilligan
Email address: andy(at)tcpd(dot)net
PostgreSQL version: 8.3RC1
Operating system: FreeBSD 4.11
Description: Segfault during table update when using convert_from()
Details:
Greetings,
It seems there exists a bug in the way character set conversion
is handled in some circumstances.
Running the test below results in the server (8.3RC1) segfaulting
every time. I haven't fully explored the extent, but it exists
with (at least) LATIN2 and LATIN9 conversion.
The database and client encoding are both UTF8.
Best regards,
-Andy
-- test case --
test=# CREATE TABLE t (id int, geo text);
CREATE TABLE
test=# INSERT INTO t (id, geo) VALUES (1,
convert_from(decode('50696f74726bf3772c20506f6c616e64','hex'), 'LATIN9'));
INSERT 0 1
test=# UPDATE t SET geo =
convert_from(decode('50696f74726bf3772c20506f6c616e64','hex'), 'LATIN9');
UPDATE 1
-- more than 1 row is needed to trigger the error
test=# INSERT INTO t (id, geo) VALUES (2,
convert_from(decode('50696f74726bf3772c20506f6c616e64','hex'), 'LATIN9'));
INSERT 0 1
test=# UPDATE t SET geo =
convert_from(decode('50696f74726bf3772c20506f6c616e64','hex'), 'LATIN9');
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
!>
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2008-01-09 22:42:19 | Re: BUG #3860: xpath crashes backend when is querying xmlagg result |
Previous Message | Stefan Kaltenbrunner | 2008-01-09 19:30:33 | Re: BUG #3865: ERROR: failed to build any 8-way joins |