Re: [pgadmin-support] Bug in SQL editor find and replace

2009-06-23 Thread David Blewett
On Tue, Jun 23, 2009 at 3:23 PM, Andres Freund wrote: > I found the issue. The code compares '(unsigned int)(-1)' with > '(size_t)(-1)' which works on 32bit but not on 64bit. The patch fixes the issue on my end. David Blewett -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.

Re: [pgadmin-support] Bug in SQL editor find and replace

2009-06-23 Thread Andres Freund
On 06/23/2009 06:59 PM, Ashesh Vashi wrote: Andres Freund wrote: On 06/23/2009 06:39 PM, Ashesh Vashi wrote: Hi Andres, I am not able to reproduce it on my end. The following details may help me reproduce on my end: 1. Is it 32 bit/64 bit linux? This is 64bit - I can create a 32bit chroot if

Re: [pgadmin-support] Bug in SQL editor find and replace

2009-06-23 Thread Andres Freund
On 06/23/2009 06:59 PM, Ashesh Vashi wrote: Hi Andres, Andres Freund wrote: On 06/23/2009 06:39 PM, Ashesh Vashi wrote: Hi Andres, I am not able to reproduce it on my end. The following details may help me reproduce on my end: 1. Is it 32 bit/64 bit linux? This is 64bit - I can create a 32b

Re: [pgadmin-support] Bug in SQL editor find and replace

2009-06-23 Thread Andres Freund
On 06/23/2009 06:39 PM, Ashesh Vashi wrote: Hi Andres, I am not able to reproduce it on my end. The following details may help me reproduce on my end: 1. Is it 32 bit/64 bit linux? This is 64bit - I can create a 32bit chroot if you have suspicions in that direction. 2. What exactly are you

Re: [pgadmin-support] Bug in SQL editor find and replace

2009-06-23 Thread Ashesh Vashi
Hi Andres, Andres Freund wrote: On 06/23/2009 06:39 PM, Ashesh Vashi wrote: Hi Andres, I am not able to reproduce it on my end. The following details may help me reproduce on my end: 1. Is it 32 bit/64 bit linux? This is 64bit - I can create a 32bit chroot if you have suspicions in that dire

Re: [pgadmin-support] Bug in SQL editor find and replace

2009-06-23 Thread Ashesh Vashi
Hi Andres, I am not able to reproduce it on my end. The following details may help me reproduce on my end: 1. Is it 32 bit/64 bit linux? 2. What exactly are you using in Find & Replace text-controls? Andres Freund wrote: On 06/23/2009 06:02 PM, David Blewett wrote: On Tue, Jun 23, 2009 at 10:5

[pgadmin-support] view the remining # of TX ID's available per db (before TX ID wraparound failure)

2009-06-23 Thread Kevin Kempter
Hi all; I want to be sure we know exactly how close we are to a tx id wraparound failure. I ran this: select datname, age(datfrozenxid) from pg_database; I assume the resulting value is the number of available tx id's left per db, is this correct? Also is there a way in 8.3 to determine whi

Re: [pgadmin-support] Bug in SQL editor find and replace

2009-06-23 Thread Andres Freund
On 06/23/2009 06:02 PM, David Blewett wrote: On Tue, Jun 23, 2009 at 10:58 AM, David Blewett wrote: I have no idea how to debug this, but maybe some of the stuff at the end might help. In helping me debug this, Andres Freund hit the same bug on the Karmic Koala Ubuntu beta. I could reproduce i

[pgadmin-support] view the remining # of TX ID's available per db (before TX ID wraparound failure)

2009-06-23 Thread Kevin Kempter
Hi all; I want to be sure we know exactly how close we are to a tx id wraparound failure. I ran this: select datname, age(datfrozenxid) from pg_database; I assume the resulting value is the number of available tx id's left per db, is this correct? Also is there a way in 8.3 to

Re: [pgadmin-support] Bug in SQL editor find and replace

2009-06-23 Thread David Blewett
On Tue, Jun 23, 2009 at 10:58 AM, David Blewett wrote: > I have no idea how to debug this, but maybe some of the stuff at the > end might help. In helping me debug this, Andres Freund hit the same bug on the Karmic Koala Ubuntu beta. David -- Sent via pgadmin-support mailing list (pgadmin-suppo

Re: [pgadmin-support] BUG: Pgadmin3 on a netbook

2009-06-23 Thread Miles Elam
Ubuntu 9.04 Netbook Remix No matter the outcome, thank you all for taking the time to look at this. I'll play around with some themes and see if I can find one that shrinks the controls down to a manageable size as a workaround. - Miles Quidquid latine dictum sit altum sonatur. On Jun 23, 2

Re: [pgadmin-support] Bug in SQL editor find and replace

2009-06-23 Thread David Blewett
Hi All: Sorry for resurrecting this bug [1], but it's been annoying me now for a few weeks (since I switched my main desktop at work from winxp to ubuntu 9.04). Symptoms: open a query editor to an 8.3 database (SSL enabled, not sure if that matters). Paste some text inside and try to find/replace

Re: [pgadmin-support] pgadmin 1.10.0 Beta 4, rev: 7855M ; Error: must be superuser to examine "shared_preload_libraries"

2009-06-23 Thread Dave Page
On Tue, Jun 23, 2009 at 3:26 PM, Massa, Harald Armin wrote: > Hello, > > in testing 1.10.0 Beta 4 on windows, I get the above quoted error when > clickin on a plpgsql function. > > it just appears once per pgadmin session, but is not really helpfull: i > never asked to examine shared_preload_librar

[pgadmin-support] pgadmin 1.10.0 Beta 4, rev: 7855M ; Error: must be superuser to examine "shared_preload_libraries"

2009-06-23 Thread Massa, Harald Armin
Hello, in testing 1.10.0 Beta 4 on windows, I get the above quoted error when clickin on a plpgsql function. it just appears once per pgadmin session, but is not really helpfull: i never asked to examine shared_preload_libraries. Harald -- GHUM Harald Massa persuadere et programmare Harald Arm

Re: [pgadmin-support] Feature Request: move column in edit grid

2009-06-23 Thread Dave Page
On Tue, Jun 23, 2009 at 2:20 PM, Willy-Bas Loos wrote: > Hi, > > Is there any way to move a column in the edit grid? > I mean, without actually changing the table in the database. > It's doesn't have to be persistent. No. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via

[pgadmin-support] Feature Request: move column in edit grid

2009-06-23 Thread Willy-Bas Loos
Hi, Is there any way to move a column in the edit grid? I mean, without actually changing the table in the database. It's doesn't have to be persistent. Cheers, Willy-Bas Loos -- "Patriotism is the conviction that your country is superior to all others because you were born in it." -- George

Re: [pgadmin-support] BUG: Pgadmin3 on a netbook

2009-06-23 Thread Rainer Bauer
Hello Dave, Tuesday, June 23, 2009, 10:32:06 AM, you wrote: DP> On Tue, Jun 23, 2009 at 9:27 AM, Rainer Bauer wrote: >> What I usually do in these cases is using a different layout depending >> on the screen resolution. For 99,x % of all users the dialogs would stay >> the way they are now and f

Re: [pgadmin-support] BUG: Pgadmin3 on a netbook

2009-06-23 Thread Magnus Hagander
Guillaume Lelarge wrote: >>> DP> Technically, yes, it would be a solution, but I doubt anyone will >>> have DP> the patience to implement it. >>> >>> There is one thing that I found while looking at the resources: The OP >>> said the table creation dialog did not fit on his 1024x600 screen. But >>>

Re: [pgadmin-support] BUG: Pgadmin3 on a netbook

2009-06-23 Thread Guillaume Lelarge
Le mardi 23 juin 2009 à 12:06:52, Rainer Bauer a écrit : > Hello Dave, > > Tuesday, June 23, 2009, 11:40:16 AM, you wrote: > > DP> It did - but if you look at the 1.10 source, you should see sizers > DP> used in pretty much every dialogue now. It took Guillaume and I > DP> (mainly Guillaume) a *sig

Re: [pgadmin-support] BUG: Pgadmin3 on a netbook

2009-06-23 Thread Rainer Bauer
Hello Dave, Tuesday, June 23, 2009, 11:40:16 AM, you wrote: DP> It did - but if you look at the 1.10 source, you should see sizers DP> used in pretty much every dialogue now. It took Guillaume and I DP> (mainly Guillaume) a *significant* amount of time to work out all the DP> platform-specific ki

Re: [pgadmin-support] BUG: Pgadmin3 on a netbook

2009-06-23 Thread Guillaume Lelarge
Le mardi 23 juin 2009 à 11:40:16, Dave Page a écrit : > On Tue, Jun 23, 2009 at 10:31 AM, Rainer Bauer wrote: > > [... downloads and peeks at ~\pgadmin3-1.8.4\pgadmin\ui\*.xrc ...] > > What I find a little bit "strange" is that the dialog elements are > > not positioned using sizer elements, but in

Re: [pgadmin-support] BUG: Pgadmin3 on a netbook

2009-06-23 Thread Dave Page
On Tue, Jun 23, 2009 at 10:31 AM, Rainer Bauer wrote: > [... downloads and peeks at ~\pgadmin3-1.8.4\pgadmin\ui\*.xrc ...] > What I find a little bit "strange" is that the dialog elements are > not positioned using sizer elements, but instead every single control > is specified with an absolute co

Re: [pgadmin-support] Feature request

2009-06-23 Thread Dave Page
On Mon, Jun 22, 2009 at 9:48 PM, Pascal Poudrier wrote: > Hi, I start using pgadmin to manage my database and I notice a small > logistic problem like : when the numeric NumLock is not activated, where is > 2 magic buttons that when put together can be very destructive as : "Del" + > "Enter". I did

Re: [pgadmin-support] BUG: Pgadmin3 on a netbook

2009-06-23 Thread Dave Page
Hello On Tue, Jun 23, 2009 at 9:27 AM, Rainer Bauer wrote: > What I usually do in these cases is using a different layout depending > on the screen resolution. For 99,x % of all users the dialogs would stay > the way they are now and for the netbook users they would fit on > screen. > > Since the

Re: [pgadmin-support] BUG: Pgadmin3 on a netbook

2009-06-23 Thread Dave Page
On Mon, Jun 22, 2009 at 5:41 PM, Guillaume Lelarge wrote: > Anyway, seems you have a point here. We probably should make them smaller. The > only way we can do this is to put the comment box on its own tab. Not > something Dave would like to have IIRC. Or we can put only "standards (common) > info