Re: length of insert stmt?

From: Barry Lind <barry(at)xythos(dot)com>
To: cmarkiew(at)commnav(dot)com
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: length of insert stmt?
Date: 2001-03-08 16:56:56
Message-ID: 3AA7B9D8.7040707@xythos.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2001-03-08 16:57:25 Re: triggers vs. 'NEW in non-rule query' -- SOLVED?
Previous Message Tim Barnard 2001-03-08 16:51:24 Re: How to check if a table exists