Thread: BUG 9.1rc1

BUG 9.1rc1

From
Claudio Oliveira
Date:
<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> 

Re: BUG 9.1rc1

From
Dave Page
Date:
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


latest pgAdmin rc

From
"Belbin, Peter"
Date:
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.


Re: latest pgAdmin rc

From
Dave Page
Date:
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


Re: latest pgAdmin rc

From
"Belbin, Peter"
Date:
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


Re: latest pgAdmin rc

From
Dave Page
Date:
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


Re: latest pgAdmin rc

From
"Belbin, Peter"
Date:
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