SELECT with row>32k hangs over SSL-Connection - Mailing list pgsql-general

From Christian Wetzig
Subject SELECT with row>32k hangs over SSL-Connection
Date
Msg-id 3F9E54F9.6030502@wetzig.de
Whole thread Raw
Responses Re: SELECT with row>32k hangs over SSL-Connection  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-general
hi,

i have a table with test_field of type "TEXT". when i do:

select test_field from test where id=1;

the connection (with psql) hangs and no output is received, so i have to
kill psql.

this occurs, at first sight, if length(test_field)>32748.

i think, in more general, the problem occurs, when the (or one) returned
row is >32k.

i can do the same without any problems, if i connect without ssl or via
local socket. the problem also occurs with DBI. so, i think it's not a
psql issue.

i'm using Postgres 7.3.4 on slackware 9.0 with openssl 0.9.7c

the workaround to disable ssl is not really sufficient :-(

i will take a deeper look at it, if it's not a known problem.


best regards,
Christian Wetzig


pgsql-general by date:

Previous
From: Tomas Larsson
Date:
Subject: Re: Stored procedures from MS Query
Next
From: Alex Page
Date:
Subject: Versioning control in PostgreSQL?