Re: BUG #6177: Size field type TEXT - Mailing list pgsql-bugs

From Kevin Grittner
Subject Re: BUG #6177: Size field type TEXT
Date
Msg-id 4E563CA402000025000406D7@gw.wicourts.gov
Whole thread Raw
In response to BUG #6177: Size field type TEXT  ("Claudio Oliveira" <claudiomsi@hotmail.com>)
Responses Re: BUG #6177: Size field type TEXT
List pgsql-bugs
"Claudio Oliveira" <claudiomsi@hotmail.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

pgsql-bugs by date:

Previous
From: "Claudio Oliveira"
Date:
Subject: BUG #6177: Size field type TEXT
Next
From: Heikki Linnakangas
Date:
Subject: Re: BUG #6170: hot standby wedging on full-WAL disk