RE: Long atributes - Mailing list pgsql-interfaces

From Peter Mount
Subject RE: Long atributes
Date
Msg-id 1B3D5E532D18D311861A00600865478CF1AEA3@EXCHANGE1
Whole thread Raw
In response to Long atributes  (Nelson Ferreira Junior <nfj@cin.ufpe.br>)
List pgsql-interfaces
Ah, there's a hardwired 8K limit in Connection (must have dated from the
distant past).

Quick fix: in src/interfaces/jdbc/org/postgresql/Connection.java, delete
lines 323 & 324

Peter

--
Peter Mount
Enterprise Support
Maidstone Borough Council
Any views stated are my own, and not those of Maidstone Borough Council

> -----Original Message-----
> From:    Nelson Ferreira Junior [SMTP:nfj@cin.ufpe.br]
> Sent:    Wednesday, May 31, 2000 8:20 PM
> To:    pgsql-interfaces@postgresql.org
> Subject:    [INTERFACES] Long atributes
> 
> 
>     Hello,
> 
>     I have to store strings larger than 8Kb in a table. Using postgreSQL
> 7.0, buit with a 32K page size, the latest JDBC driver and JDK1.2
>     I still get a SQLException "SQL statement is to long" when I try to do
> a insert with a big string, although the homepage says that there is no
> query size limit anymore (but the tuples still have to fin in one disk
> page).
> 
> 
>                                                Thanks


pgsql-interfaces by date:

Previous
From: Stephen Crawley
Date:
Subject: Is it possible to "truncate" a LOB?
Next
From: Peter Mount
Date:
Subject: RE: Re: Simple bug in JDBC interface