On Aug 30, 2011, at 3:45 PM, Dave Page wrote: > On Tue, Aug 30, 2011 at 9:42 PM, Strauch, Sheldon > <sstra...@enovafinancial.com> wrote: >> On Aug 30, 2011, at 2:52 PM, Dave Page wrote: >>> Hi >>> >>> On Tue, Aug 30, 2011 at 8:18 PM, Strauch, Sheldon >>> <sstra...@enovafinancial.com> wrote: >>>> Hi, >>>> >>>> I just downloaded RC1. It browses databases fine, but crashes when I open >>>> the SQL window. >>>> Exact steps to reproduce: >>>> * Open pgAdmin >>>> * Open any database >>>> * Click on the SQL icon in the button bar >>>> From the dump it appears the crash happens deep in Apple territory. I hope >>>> this report helps. Please let me know if there is anything additional I >>>> can provide. >>> >>> I can't reproduce this here. Does removing/renaming the query history >>> file help (~/.pgadmin_histoqueries)? >>> >>> -- >>> Dave Page >>> Blog: http://pgsnake.blogspot.com >>> Twitter: @pgsnake >>> >>> EnterpriseDB UK: http://www.enterprisedb.com >>> The Enterprise PostgreSQL Company >> >> >> Yes! That fixes the issue. Thank you so much. > > Can you see anything in the file that seems like it might cause a > problem (corruption, huge queries, that sort of thing)? > > -- > Dave Page > Blog: http://pgsnake.blogspot.com > Twitter: @pgsnake > > EnterpriseDB UK: http://www.enterprisedb.com > The Enterprise PostgreSQL Company
Well, the file was 1.3M lines long, including an entire dump from over a year ago. I did not examine the entire file. What I saw looked reasonably well-formed. I suspect the size of the file is the actual culprit. It was a bit disturbing to see "ALTER ROLE xxxx WITH PASSWORD 'yyyyyy';" in clear-text. However, I suppose that can't be avoided. Once again, thank you so much for your help, Sheldon Strauch Sr. Database Developer sstra...@enovafinancial.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
