pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  

help / color / mirror / Atom feed

libpq query length limit
2+ messages / 2 participants
[nested] [flat]

* libpq query length limit
@ 2008-04-06 23:58  Charles Seaton <cseaton@stccmop.org>
  0 siblings, 1 reply; 2+ messages in thread

From: Charles Seaton @ 2008-04-06 23:58 UTC (permalink / raw)
  To: pgsql-interfaces

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.

Is there a limit on the length of a query, and is there a way around this?

thanks,

Charles Seaton




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: libpq query length limit
@ 2008-04-08 14:50  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Charles Seaton <cseaton@stccmop.org>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2008-04-08 14:50 UTC (permalink / raw)
  To: Charles Seaton <cseaton@stccmop.org>; +Cc: pgsql-interfaces

Charles Seaton <cseaton@stccmop.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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2008-04-08 14:50 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-04-06 23:58 libpq query length limit Charles Seaton <cseaton@stccmop.org>
2008-04-08 14:50 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox