Re: [HACKERS - GENERAL] PQexec() 8191 bytes limit and text fields

Hi Steve, lets approach this from the other angle...

I don't see anywhere in your email where you say what makes you think that
you can only pass a query > 8191 bytes in size to PG. What exactly makes you
think that there is some hard coded limit? This limit is not in 7.1.2 so
either you have outdated source code or the problem is somewhere else..

Good luck!

-Mitch

----- Original Message -----
From: "Steve Howe" <howe(at)carcass(dot)dhs(dot)org>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Sent: Wednesday, July 18, 2001 1:30 PM
Subject: Re: [HACKERS] PQexec() 8191 bytes limit and text fields

> Hi...
>
> The problem is, I compiled it myself from original PostgreSQL
> version 7.12 C sources using Microsoft's Visual C++ 6.0. I had to compile
it
> because I add a function to free the handlers returned from PQnotifies(),
or
> I would have a memory leak.
> The resulting libpq.dll seems ok in everything but this issue...
> I guess I'll do it again, after checking the sources :)
> Other people reported me they send large queries with no problems,
> so I guess it should really be a problem of mine...
>
> Best Regards,
> Steve Howe
>
> ----- Original Message -----
> From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
> To: "Steve Howe" <howe(at)carcass(dot)dhs(dot)org>
> Cc: <pgsql-hackers(at)postgresql(dot)org>
> Sent: Wednesday, July 18, 2001 1:14 PM
> Subject: Re: [HACKERS] PQexec() 8191 bytes limit and text fields
>
>
> > "Steve Howe" <howe(at)carcass(dot)dhs(dot)org> writes:
> > > Writing my interface application, which use the PQexec
library,
> I
> > > came across the PQexec() queries 8191 bytes limit.
> >
> > You must have a very out-of-date library. Time to update.
> >
> > regards, tom lane
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>