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