Skip site navigation (1) Skip section navigation (2)

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>,<bruce(at)momjian(dot)us>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #6177: Size field type TEXT
Date: 2011-08-25 20:12:22
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
Claudio Oliveira <claudiomsi(at)hotmail(dot)com> wrote:
> I'm doing the test in PGAdmin.
> Must be a bug in PGAdmim.
> I'm sorry I have not tested in psql
> create table txt (val text);
> txt insert into values ​​(repeat ('x', 4500));
> char_length select (val) from txt;
> txt insert into values ​​(repeat ('x', 4685));
> char_length select (val) from txt;
> select *, length (val) val is null, (val ~ 'x') from txt;
Hmm.  Maybe you should try taking this to the pgadmin-support list. 
Your script came out sort of mangled in email, and apparently has
funny characters in it because I couldn't copy/paste and modify -- I
had to retype.  But this runs fine in psql for me:  (Printing the
hundreds of x's omitted from the post, but that looks OK to me,
test=# create table txt (val text);
test=# insert into txt values (repeat('x', 4500));
test=# insert into txt values (repeat('x', 4685));
test=# select char_length(val), val is null, (val ~ 'x') from txt;
 char_length | ?column? | ?column?
        4500 | f        | t
        4685 | f        | t
(2 rows)

In response to

pgsql-bugs by date

Next:From: KenDate: 2011-08-26 08:31:17
Subject: BUG #6179: "service postgresql-9.0 stop" does not stop postgresql server
Previous:From: Noah HamersloughDate: 2011-08-25 19:05:34
Subject: BUG #6178: date_trunc : interval units "week" not supported contradicts documentation

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group