| From: | John David Garza <garza(at)cjas(dot)org> |
|---|---|
| To: | Nelson Ferreira Junior <nelson(at)radix(dot)com(dot)br> |
| Cc: | pgsql-interfaces(at)postgresql(dot)org |
| Subject: | Re: Large strings |
| Date: | 2000-04-19 17:59:13 |
| Message-ID: | Pine.BSF.4.10.10004191356410.79249-100000@localhost |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-interfaces |
Hello,
If your strings are much larger than the limit, it might be more efficient
to store the string in it's own file and just store the location of that
file in the db.
John David Garza
garza(at)keyframe(dot)cjas(dot)org
On Wed, 19 Apr 2000, Nelson Ferreira Junior wrote:
> I reinstalled Postgre with page size set to 32K, but it still doesn't
> work. I got the following errors. Is it complaining abou the size of the
> query itself ?
>
> * Java program (even using a prepared statement)
> SQLException: The SQL Statement is too long
> * Puting the query in a file and calling with psql -f :
> ERROR: Tuple is too big: size 11424, max size 8140
>
> Thanks
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tibor Laszlo | 2000-04-19 18:47:33 | Re: ODBC not reporting RI violations. |
| Previous Message | Ken J. Wright | 2000-04-19 16:05:53 | Re: Inserting NULL with pgaccess |