Re: large text fields - Mailing list pgsql-general

From Daniel Stolk
Subject Re: large text fields
Date
Msg-id 38ED155C.50C8E8B3@email.com
Whole thread Raw
In response to large text fields  ("Kevin Heflin" <kheflin@shreve.net>)
List pgsql-general
Use large objects

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.
>
> Kevin
>
> ----------------------------------------------------------------
> Kevin Heflin       | ShreveNet, Inc.      | Ph:318.222.2638 x103
> VP/Production      | 333 Texas St #619    | FAX:318.221.6612
> kheflin@shreve.net | Shreveport, LA 71101 | http://www.shreve.net
> -----------------------------------------------------------------

pgsql-general by date:

Previous
From: "Ross J. Reedstrom"
Date:
Subject: Re: Functions in postgres
Next
From: Alfred Perlstein
Date:
Subject: tricky date manipulations?