pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedLong atributes
3+ messages / 3 participants
[nested] [flat]
* Long atributes
@ 2000-05-31 19:19 Nelson Ferreira Junior <nfj@cin.ufpe.br>
0 siblings, 1 reply; 3+ messages in thread
From: Nelson Ferreira Junior @ 2000-05-31 19:19 UTC (permalink / raw)
To: pgsql-interfaces
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Long atributes
@ 2000-06-02 16:01 Tom Lane <tgl@sss.pgh.pa.us>
parent: Nelson Ferreira Junior <nfj@cin.ufpe.br>
0 siblings, 0 replies; 3+ messages in thread
From: Tom Lane @ 2000-06-02 16:01 UTC (permalink / raw)
To: Nelson Ferreira Junior <nfj@cin.ufpe.br>; +Cc: pgsql-interfaces
Nelson Ferreira Junior <nfj@cin.ufpe.br> writes:
> 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,
I believe the JDBC driver still has a query length limit in it :-(
(Hey Peter, is anything likely to be done about that soon?)
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
* RE: Long atributes
@ 2000-06-06 07:20 Peter Mount <petermount@it.maidstone.gov.uk>
0 siblings, 0 replies; 3+ messages in thread
From: Peter Mount @ 2000-06-06 07:20 UTC (permalink / raw)
To: 'Nelson Ferreira Junior' <nfj@cin.ufpe.br>; 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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2000-06-06 07:20 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-05-31 19:19 Long atributes Nelson Ferreira Junior <nfj@cin.ufpe.br>
2000-06-02 16:01 ` Tom Lane <tgl@sss.pgh.pa.us>
2000-06-06 07:20 RE: Long atributes Peter Mount <petermount@it.maidstone.gov.uk>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox