I am now able to replicate this problem more consistently. It seems
that these steps will cause the problem every time on my computer:
1) Boot WinXP, sp2 (possibly requiring some or all of on my setup: a
Thinkpad T43 with ATI Control Center installed + external monitor set
to primary + 2bg ram + Microsoft patch for hibernation of >1gb
2) Load PgAdmin 1.8 RC1
3) Open SQL Window to local Pg server
4) Hibernate machine
5) Open a new SQL Windows for local Pg server
6) Notice that SQL window doesn't have sql input box displayed.
Workaround: Uncheck and recheck View/Output pane and problem goes away.
The key is that it always seem to cause a problem when opening a new
sql window in Pg admin after hibernating but only sometimes causes a
problem for an existing open sql window.
I hope this helps, though it's a pretty minor problem in the end.
>Thanks for the help. Now I'm even having trouble replicating on my
>machine after restarting cleanly a few times. I tried everything I
>could think of that I was doing on the machine that caused it to
>happen but now it's working fine - so I think this is a Windows issue
>that might victimize your software in some corner cases, but under
>normal circumstances your product is returning from hibernation
>Thanks for the look at the issue and I apologize for the goose chase.
At 12:40 PM 10/18/2007, Joris Dobbelsteen wrote:
> >-----Original Message-----
> >From: pgadmin-support-owner(at)postgresql(dot)org
> >[mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of Dave Page
> >Sent: donderdag 18 oktober 2007 9:46
> >To: Steve Midgley
> >Cc: pgadmin-support(at)postgresql(dot)org
> >Subject: Re: [pgadmin-support] WinXP Hibernation problem
> >Steve Midgley wrote:
> >> Hi,
> >> I'm not sure if this is a general problem but here's the
> >steps I undertook:
> >> Running IBM T43 w/WinXP SP2 / current patches (+special
> >patch for >1GB
> >> hibernation)
> >> Running PgAdmin 1.8 beta 5 connected to local pg server with sql
> >> window open Put computer into Hibernation Woke it up SQL window
> >> results set displayed but no sql input window Closed
> >PgAdmin, upgraded
> >> to 1.8RC1 Reopened and same problem, but then I figured out that
> >> toggling "View/Output Pane" off then on again fixed the view
> >> I'm not sure if this is related to the fact that I'm a dual
> >> setup (which sometimes also goes wonky on hibernation wakeup).
> >> Maybe others can see if it's a general problem or just me?
> >> the sql input pane disappears when waking from hibernation
> >on a laptop
> >> with a sql window still open. If it's not as general as that, it
> >> be something to ignore.
> >Unfortunately my laptop doesn't seem to support hibernation
> >(I'm running XP Pro on a MacBook Pro) so I can't test this.
> >Anyone else able to reproduce it, preferrably with a debugger to
>You should be able to enable it in
>-> "Power Options"
>-> "Hibernate" tab
>-> "Enable hibernation"
>Unfortunally I'm running pgAdmin III 1.6.3 and put my laptop (IBM T60
>with ATI video card) into sleep regarly (only reboot when the thing
>hangs itself up after ripping out all my external hardware too fast).
>Steve, can you check the problem exists with standby too? That should
>work on your laptop (the university where I study had issued such
>laptops to their students some years ago and they work fine with
>standby). Alternatively you can try to make a system backup and try a
>driver update, since the wonky multi-monitor seems scary.
> >> Thanks for such an excellent product and for your time and energy
> >> making it so.
> >you're welcome.
>I don't have any disk space for hibernate, but with sleep this version
>works as perfectly. I'll try the new version tomorrow. Issue is, the
>current version works very well, thus I can only agree with Steve...
pgadmin-support by date
|Next:||From: Joris Dobbelsteen||Date: 2007-10-19 19:46:10|
|Subject: Re: WinXP Hibernation problem (replicated)|
|Previous:||From: Jyrki Wahlstedt||Date: 2007-10-19 13:00:31|
|Subject: Re: pgAdmin 1.8RC1 - failed to launch on Mac OS X|