Re: libpq query length limit

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Charles Seaton <cseaton(at)stccmop(dot)org>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: libpq query length limit
Date: 2008-04-08 14:50:27
Message-ID: 1111.1207666227@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Charles Seaton <cseaton(at)stccmop(dot)org> writes:
> I am using libpq to access a PostgreSQL 8.2.7 database.
> I am encountering segfault errors when the query length exceeds some
> value greater than 633 characters and less than 2492 characters. The
> database log shows the message
> LOG: 08P01: unexpected EOF on client connection

> The query that causes problems through libpq can be run directly in psql
> without a problem.

Almost certainly, this is a bug within the code calling libpq, and not
in libpq itself. Many people routinely use queries much longer than
that ...

regards, tom lane

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message Drago 2008-04-15 15:00:28 NOTIFY connection lost
Previous Message Francisco Figueiredo Jr. 2008-04-07 17:22:09 Npgsql2 Beta3 Released!! - Correction