RE: length of insert stmt?

From: "chris markiewicz" <cmarkiew(at)commnav(dot)com>
To: "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "'Gavin Sherry'" <swm(at)linuxworld(dot)com(dot)au>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: RE: length of insert stmt?
Date: 2001-03-08 15:39:26
Message-ID: 01a401c0a7e5$f5e0e580$dbb846c6@cmarkiewicz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

i am using jdbc7.0-1.2...postgres 7.0.2.

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Thursday, March 08, 2001 10:28 AM
To: Gavin Sherry
Cc: chris markiewicz; pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] length of insert stmt?

Gavin Sherry <swm(at)linuxworld(dot)com(dot)au> writes:
> You seem to have hit the 8Kb row limit.

No, I think he's hit some limit on the size of a query string. Before
about 7.0, there was a limit on the textual length of queries. We got
rid of it in the backend and libpq, but I think some of the lesser-used
interface libraries still think they can/should limit query length.

Chris didn't say what version of what interface he was using, though...

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-03-08 15:49:51 Re: length of insert stmt?
Previous Message Tom Lane 2001-03-08 15:32:08 Re: Escaping underscores in LIKE