Обсуждение: Input strings > 16 K?

I recently increased the default tuple size to 32K on Postgres 7.0.2
with no problems. My colleague, however, told me that I can't pass a
text string greater than 16 K into the PQexec C function. So his claim
is that the only way I can actually get > 16 K into the tuple is through
a binary cursor. Anyone know if this is correct? Is there some
configuration variable I can change to up this to the same size as the
maximum tuple length?

Thanks.
-Tony

"G. Anthony Reina" <reina@nsi.edu> writes:
> I recently increased the default tuple size to 32K on Postgres 7.0.2
> with no problems. My colleague, however, told me that I can't pass a
> text string greater than 16 K into the PQexec C function.

There *was* such a restriction in libpq, before 7.0.  His info is
obsolete...
        regards, tom lane

Tom Lane wrote:

> "G. Anthony Reina" <reina@nsi.edu> writes:
> > I recently increased the default tuple size to 32K on Postgres 7.0.2
> > with no problems. My colleague, however, told me that I can't pass a
> > text string greater than 16 K into the PQexec C function.
>
> There *was* such a restriction in libpq, before 7.0.  His info is
> obsolete...
>
>                         regards, tom lane

Thanks Tom. Good to know that the restriction was lifted.

-Tony