Re: length of insert stmt? - Mailing list pgsql-general

From Barry Lind
Subject Re: length of insert stmt?
Date
Msg-id 3AA7B9D8.7040707@xythos.com
Whole thread Raw
In response to RE: length of insert stmt?  ("chris markiewicz" <cmarkiew@commnav.com>)
List pgsql-general
The sql statement length limit was a bug in the jdbc driver that was
fixed in 7.0.3.

--Barry


chris markiewicz wrote:

> i am using jdbc7.0-1.2...postgres 7.0.2.
>
> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> Sent: Thursday, March 08, 2001 10:28 AM
> To: Gavin Sherry
> Cc: chris markiewicz; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] length of insert stmt?
>
>
> Gavin Sherry <swm@linuxworld.com.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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster


pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: triggers vs. 'NEW in non-rule query' -- SOLVED?
Next
From: "Tim Barnard"
Date:
Subject: Re: How to check if a table exists