SELECT with row>32k hangs over SSL-Connection

From: Christian Wetzig <postgres(at)wetzig(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: SELECT with row>32k hangs over SSL-Connection
Date: 2003-10-28 11:37:29
Message-ID: 3F9E54F9.6030502@wetzig.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alex Page 2003-10-28 11:43:44 Versioning control in PostgreSQL?
Previous Message Tomas Larsson 2003-10-28 11:23:15 Re: Stored procedures from MS Query