Thread: BUG 9.1rc1
<div dir="ltr"><span class="Apple-style-span" style="color: rgb(42, 42, 42); font-family: 'Segoe UI', Tahoma, Verdana,
Arial,sans-serif; line-height: 17px; background-color: rgb(255, 255, 255); ">Hi,<div style="line-height: 17px; "><br
style="line-height:17px; " /></div><div style="line-height: 17px; "><div style="line-height: 17px; ">Use version 8.4
andhave no issues with the field type TEXT.</div><div style="line-height: 17px; "><br style="line-height: 17px; "
/></div><divstyle="line-height: 17px; ">In version 9.1rc1 is limited to 4680 characters.</div><div style="line-height:
17px;"><br style="line-height: 17px; " /></div><div style="line-height: 17px; ">Test</div></div><div
style="line-height:17px; "><br style="line-height: 17px; " /></div><div style="line-height: 17px; "><div
style="line-height:17px; "> create table txt (val text);</div><div style="line-height: 17px; "> insert into txt values
(repeat('x', 4500));</div><div style="line-height: 17px; "> insert into txt values (repeat ('x', 4685));</div><div
style="line-height:17px; "><br style="line-height: 17px; " /></div><div style="line-height: 17px; "> select *, length
(val)val is null, (val ~ 'x') from txt;</div></div><div style="line-height: 17px; "><br style="line-height: 17px; "
/></div><divstyle="line-height: 17px; ">Thank You.</div></span></div>
On Fri, Aug 26, 2011 at 5:22 PM, Claudio Oliveira
<claudiomsi@hotmail.com> wrote:
> Hi,
> Use version 8.4 and have no issues with the field type TEXT.
> In version 9.1rc1 is limited to 4680 characters.
> Test
> create table txt (val text);
> insert into txt values (repeat ('x', 4500));
> insert into txt values (repeat ('x', 4685));
> select *, length (val) val is null, (val ~ 'x') from txt;
> Thank You.
It works for me... but any error as you describe would be a PostgreSQL
issue, not pgAdmin (which just passes the queries to the server
unmodified). You should ask on one of the PostgreSQL lists, such as
pgsql-general@postgresql.org.
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
I'm running pgAdmin on a windows 2008 os. When the 'view data options' dialog appears to allow me to supply a filter criteria, I see the 'validate' button, but notany other buttons. If I drag the lower window frame downwards, only then do I get to see the 'OK' and 'Cancel' buttons. Regards, Peter.
On Tue, Aug 30, 2011 at 10:00 PM, Belbin, Peter <Peter.Belbin@paetec.com> wrote: > I'm running pgAdmin on a windows 2008 os. > > When the 'view data options' dialog appears to allow me to supply a filter criteria, I see the 'validate' button, but notany other buttons. > > If I drag the lower window frame downwards, only then do I get to see the 'OK' and 'Cancel' buttons. I cannot reproduce this on Windows or Mac, with 1.12.3 or 1.14.0rc1. Are you using any non-standard font settings etc? -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
Not sure. Would you please provide me with a list of the 'standard' values so that I can compare / reset. Also, it does seem that there really is no 'reset' button on the font related config panes. It would be good to have that(either a 'reset' or 'default' button) so that what you're calling the 'standard' values can be chosen again, if a differentfont gets chosen at some point. Btw: even if I'm not using standard settings, shouldn't it be taking the font sizes into consideration when sizing thesethings so that the user still sees everything they need to? Regards, Peter. -----Original Message----- From: Dave Page [mailto:dpage@pgadmin.org] Sent: Tuesday, August 30, 2011 4:21 PM To: Belbin, Peter Cc: pgadmin-support@postgresql.org Subject: Re: [pgadmin-support] latest pgAdmin rc On Tue, Aug 30, 2011 at 10:00 PM, Belbin, Peter <Peter.Belbin@paetec.com> wrote: > I'm running pgAdmin on a windows 2008 os. > > When the 'view data options' dialog appears to allow me to supply a filter criteria, I see the 'validate' button, but notany other buttons. > > If I drag the lower window frame downwards, only then do I get to see the 'OK' and 'Cancel' buttons. I cannot reproduce this on Windows or Mac, with 1.12.3 or 1.14.0rc1. Are you using any non-standard font settings etc? -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
On Wed, Aug 31, 2011 at 5:58 PM, Belbin, Peter <Peter.Belbin@paetec.com> wrote: > Not sure. > > Would you please provide me with a list of the 'standard' values so that I can compare / reset. > > Also, it does seem that there really is no 'reset' button on the font related config panes. It would be good to have that(either a 'reset' or 'default' button) so that what you're calling the 'standard' values can be chosen again, if a differentfont gets chosen at some point. > > Btw: even if I'm not using standard settings, shouldn't it be taking the font sizes into consideration when sizing thesethings so that the user still sees everything they need to? I'm referring to OS font settings, not pgAdmin ones. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
Ah. Ok, I'm using what I think is the standard Windows Aero color scheme which is then using Segoe UI size 9 as the window menutext. I then went through pgAdmin and changed it to use the same font, and the filter dialog box is now showing the 'ok' and 'cancel'buttons. So what is going on here? I tried changing the font size from 9 to 10 within the pgAdmin options, and it is still showing the filter dialog box correctly. I then changed it to ms sans serif 10, and it appears ok. I then changed it to ms reference sans 9, and it still appears ok. I don't know, but it seems fine now. Very strange. I'll get back to you if I see something happening odd again in future. Regards, Peter -----Original Message----- From: Dave Page [mailto:dpage@pgadmin.org] Sent: Wednesday, August 31, 2011 2:03 PM To: Belbin, Peter Cc: pgadmin-support@postgresql.org Subject: Re: [pgadmin-support] latest pgAdmin rc On Wed, Aug 31, 2011 at 5:58 PM, Belbin, Peter <Peter.Belbin@paetec.com> wrote: > Not sure. > > Would you please provide me with a list of the 'standard' values so that I can compare / reset. > > Also, it does seem that there really is no 'reset' button on the font related config panes. It would be good to have that(either a 'reset' or 'default' button) so that what you're calling the 'standard' values can be chosen again, if a differentfont gets chosen at some point. > > Btw: even if I'm not using standard settings, shouldn't it be taking the font sizes into consideration when sizing thesethings so that the user still sees everything they need to? I'm referring to OS font settings, not pgAdmin ones. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company