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
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 |