Re: BUG #6177: Size field type TEXT

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Claudio Oliveira" <claudiomsi(at)hotmail(dot)com>, <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #6177: Size field type TEXT
Date: 2011-08-25 17:14:28
Message-ID: 4E563CA402000025000406D7@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Claudio Oliveira" <claudiomsi(at)hotmail(dot)com> wrote:

> Use version 8.4 and have no issues with the field type TEXT.
>
> In version 9.1rc1 is limited to 4680 characters.
>
> Where do I change that size?

test=# create table txt (val text);
CREATE TABLE
test=# insert into txt values (repeat('long string', 1000000));
INSERT 0 1
test=# select char_length(val) from txt;
char_length
-------------
11000000
(1 row)

What makes you think it's limited to 4680 characters?

-Kevin

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Heikki Linnakangas 2011-08-25 17:16:45 Re: BUG #6170: hot standby wedging on full-WAL disk
Previous Message Robert Haas 2011-08-25 16:11:35 Re: BUG #6170: hot standby wedging on full-WAL disk