message type 0x44 arrived from server while idle

Поиск
Список
Период
Сортировка
От Tomas Berndtsson
Тема message type 0x44 arrived from server while idle
Дата
Msg-id 80isygv27y.fsf@junk.nocrew.org
обсуждение исходный текст
Список pgsql-general
Hi,

I have a pretty simple table, log_rir:

 id         | integer                  | not null default nextval('"log_rir_id_seq"'::text)
 first_time | timestamp with time zone | default ('now'::text)::timestamp(6) with time zone
 last_time  | timestamp with time zone | default ('now'::text)::timestamp(6) with time zone
 facility   | text                     |
 message    | text                     |
 key        | text                     |
 status     | text                     |
 counter    | integer                  |

The text fields are quite small, except for the message field, which
can be larger. The others are about 20-40 characters.

Now, the problem occurs when the message field contains a string
larger than about 32000 (I'd guess 32767). From my C application,
using libpq, when I'm selecting from this table, I get:

message type 0x44 arrived from server while idle

However, when I run the same select from psql, it works fine. This is
a Solaris 8 running PostgreSQL 7.2.1. Has anyone seen this, or know
what's causing it. If I just delete the row with the long message
field, the same select works from the application too.


Tomas

В списке pgsql-general по дате отправления:

Предыдущее
От: "Envex Developments"
Дата:
Сообщение: Trigger / Function: Getting column name of UPDATE
Следующее
От: "Envex Developments"
Дата:
Сообщение: Determine column name from trigger