| From: | Lamar Owen <lamar(dot)owen(at)wgcr(dot)org> |
|---|---|
| To: | Kevin Heflin <kheflin(at)shreve(dot)net> |
| Cc: | psql <pgsql-general(at)postgreSQL(dot)org> |
| Subject: | Re: large text fields |
| Date: | 2000-04-06 20:22:47 |
| Message-ID: | 38ECF217.56C9392D@wgcr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Kevin Heflin wrote:
>
> when ever I've dealt with a field that would require more text than 250
> characters, I've always used the 'text' datatype. It appears I've hit an
> example where this won't work. users are trying to insert what amounts to
> about 2 pages worth of text and I'm seeing this error:
>
> PostgresSQL query failed: ERROR: Tuple is too big: size 10000
>
> Are there any other options other than using a BLOB datatype ? which I'm
> completely unfamiliar with.
Recompile with a larger BLKSIZ of 16K or 32K. Or wait on TOAST.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ross J. Reedstrom | 2000-04-06 22:04:18 | Re: Functions in postgres |
| Previous Message | Kevin Heflin | 2000-04-06 19:48:24 | large text fields |