Thread: ...
Renaming a table by right clicking on the table, selecting Properties... on the contextual menu and then editing the Name field on the Properties tab and then clicking on the OK button will consistently cause a freeze up of the pgAdminIII app. I have to then force quit the app using the Task Manager. I have found this problem on two different sites that I am accessing using the built in Windows Terminal Services RDP client (Windows Server 2008 R2 Standard, Service Pack 1). Note that each time I have done this I between clicking on the OK button and the freeze up a "hints' dialog is shown giving me a hint on Primary Keys (the tables in question do not have primary keys since they are only used to import data from text files); when I acknowledge/dismiss the hint by clicking OK, the freeze up occurs. Also, when I relaunch pgAdminIII I have noticed that the rename successfully occurred.
Gary Giumarra
DealerBuilt-Lightyear Dealer Technologies, LLC.
Senior Accounting Developer
Bakersfield, CA
661-399-4040 (day + eve.)
661-301-3204 (mobile + text)
gary.giumarra@dealerbuilt.com
On Wed, 2012-09-26 at 10:36 -0700, Gary Giumarra wrote: > > Renaming a table by right clicking on the table, selecting Properties... on the > contextual menu and then editing the Name field on the Properties tab and then > clicking on the OK button will consistently cause a freeze up of the pgAdminIII > app. I have to then force quit the app using the Task Manager. I have found this > problem on two different sites that I am accessing using the built in Windows > Terminal Services RDP client (Windows Server 2008 R2 Standard, Service Pack 1). > Note that each time I have done this I between clicking on the OK button and the > freeze up a "hints' dialog is shown giving me a hint on Primary Keys (the tables > in question do not have primary keys since they are only used to import data > from text files); when I acknowledge/dismiss the hint by clicking OK, the freeze > up occurs. Also, when I relaunch pgAdminIII I have noticed that the rename > successfully occurred. > it doesn't freeze for me. Are you using the 1.16 release ? if not, try and tell us if it still happens. Thanks. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com
Just did it 4 more times with the same result (freeze up and need to force quit). Prior to the last 2 times I turned off the Guru hints on the theory that might have something to do with it (since the Guru hints dialog always popped up between the time I clicked OK and the freeze up), but it still froze up.
Here is the command in the SQL tab (if I execute this from a SQL Editor window, there is no problem): ALTER TABLE conversion.ac_journalpost_rev_cc_0924y
RENAME TO ac_journalpost_rev_cc_0924;
RENAME TO ac_journalpost_rev_cc_0924;
pgAdminIII version in about window: Version 1.16.0 (Sep 7 2012, rev: REL-1_16_0)
I forgot to mention last time (though I'm not sure it matters), that the server is version 8.4.11 on x86_64-pc-linux-gnu (Ubuntu 4.4.3-4ubuntu5)
If this is any help, here are the "problem details" from the Window error dialog:
Problem signature:
Problem Event Name: APPCRASH
Application Name: pgadmin3.exe
Application Version: 1.16.0.99
Application Timestamp: 5049dad5
Fault Module Name: LIBPQ.dll
Fault Module Version: 9.2.0.12250
Fault Module Timestamp: 50496af3
Exception Code: c0000005
Exception Offset: 00005d31
OS Version: 6.1.7601.2.1.0.16.7
Locale ID: 1033
Additional Information 1: 0a9e
Additional Information 2: 0a9e372d3b4ad19135b953a78882e789
Additional Information 3: 0a9e
Additional Information 4: 0a9e372d3b4ad19135b953a78882e789
Read our privacy statement online:
http://go.microsoft.com/fwlink/?linkid=104288&clcid=0x0409If the online privacy statement is not available, please read our privacy statement offline:
C:\Windows\system32\en-US\erofflps.txt
Gary Giumarra
DealerBuilt-Lightyear Dealer Technologies, LLC.
From: Guillaume Lelarge <guillaume@lelarge.info>
To: Gary Giumarra <ggiumarra@yahoo.com>
Cc: pgadmin-support@postgresql.org
Sent: Fri, September 28, 2012 10:43:35 AM
Subject: Re: [pgadmin-support]
On Wed, 2012-09-26 at 10:36 -0700, Gary Giumarra wrote:
>
> Renaming a table by right clicking on the table, selecting Properties... on the
> contextual menu and then editing the Name field on the Properties tab and then
> clicking on the OK button will consistently cause a freeze up of the pgAdminIII
> app. I have to then force quit the app using the Task Manager. I have found this
> problem on two different sites that I am accessing using the built in Windows
> Terminal Services RDP client (Windows Server 2008 R2 Standard, Service Pack 1).
> Note that each time I have done this I between clicking on the OK button and the
> freeze up a "hints' dialog is shown giving me a hint on Primary Keys (the tables
> in question do not have primary keys since they are only used to import data
> from text files); when I acknowledge/dismiss the hint by clicking OK, the freeze
> up occurs. Also, when I relaunch pgAdminIII I have noticed that the rename
> successfully occurred.
>
it doesn't freeze for me. Are you using the 1.16 release ? if not, try
and tell us if it still happens.
Thanks.
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support