Thread: pgAdmin Crashes When Opening a *.sql File From Windows Explorer

<div class="Section1"><p class="MsoNormal">PGAdmin Version 1.12.2 (Dec 13 2010, REL-1_12_2)<p
class="MsoNormal">Workstation- Windows XP x64 SP2<p class="MsoNormal"> <p class="MsoNormal">When I right click on a
*.sqlfile in Windows Explorer and select Open With pgAdmin III the splash screen is shown followed by the login box.
Aftermaking login box selections, I receive an error window stating “pgAdmin III – Postgres SQL Tools has encountered a
problemand needs to close. We are sorry for the inconvenience.”<p class="MsoNormal"> <p class="MsoNormal">I am able to
openand utilize pgAdmin from the start menu and open *.sql files from the file>open in the sql tool.<p
class="MsoNormal"> <pclass="MsoNormal"> <p class="MsoNormal"> <p class="MsoNormal">Russell Galyon</div><br /><hr
/><fontcolor="Black" face="Arial" size="2">The information contained in this Email message is private and confidential.
Itmay contain Protected Health Information deemed confidential by HIPAA regulations. It is intended only for the use of
theindividual(s) named above, and the privileges are not waived by virtue of this information having been sent by
Email.Any use, dissemination, distribution or copying of this the information contained in this communication is
strictlyprohibited by anyone except the named individual or that person's agent. If you have received this Email in
error,please notify the sender immediately and destroy this Email. Thank You.<br /></font> 

Dhiraj,

Can you take a look at this issue please?

Thanks!

On Tue, Jan 4, 2011 at 10:37 PM, Russell L. Galyon
<Russell.Galyon@centerstoneresearch.org> wrote:
> PGAdmin Version 1.12.2 (Dec 13 2010, REL-1_12_2)
>
> Workstation - Windows XP x64 SP2
>
>
>
> When I right click on a *.sql file in Windows Explorer and select Open With
> pgAdmin III the splash screen is shown followed by the login box. After
> making login box selections, I receive an error window stating “pgAdmin III
> – Postgres SQL Tools has encountered a problem and needs to close. We are
> sorry for the inconvenience.”
>
>
>
> I am able to open and utilize pgAdmin from the start menu and open *.sql
> files from the file>open in the sql tool.
>
>
>
>
>
>
>
> Russell Galyon
>
> ________________________________
> The information contained in this Email message is private and confidential.
> It may contain Protected Health Information deemed confidential by HIPAA
> regulations. It is intended only for the use of the individual(s) named
> above, and the privileges are not waived by virtue of this information
> having been sent by Email. Any use, dissemination, distribution or copying
> of this the information contained in this communication is strictly
> prohibited by anyone except the named individual or that person's agent. If
> you have received this Email in error, please notify the sender immediately
> and destroy this Email. Thank You.
>



--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Nothing is wrong with my associations that I am aware of (Windows XP x64, Sophos). I tried this on a co-workers pc
(WindowsVista, Sophos) and got the same result. Then because of your note I tried on a non work related laptop (Windows
7,McAfee) and it worked without issue. Given that I am guessing this is either something to do with an Active Directory
policyour virus protection. Has anyone had issues with specific policy settings or Sophos? 
________________________________________
From: Dhiraj Chawla [dhiraj.chawla@enterprisedb.com]
Sent: Monday, January 10, 2011 1:52 AM
To: Russell L. Galyon
Cc: pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] pgAdmin Crashes When Opening a *.sql File From Windows Explorer

Hi Russell,

I am not able to reproduce this issue on my Windows system with the steps that you have mentioned below.

I just wanted to ask if you have done any manual file association of *.sql file with pgadmin3 on your windows system?
Ifso can you share information about that with us? 

Regards,
Dhiraj

On Thu, Jan 6, 2011 at 3:55 PM, Dave Page <dpage@pgadmin.org<mailto:dpage@pgadmin.org>> wrote:
Dhiraj,

Can you take a look at this issue please?

Thanks!

On Tue, Jan 4, 2011 at 10:37 PM, Russell L. Galyon
<Russell.Galyon@centerstoneresearch.org<mailto:Russell.Galyon@centerstoneresearch.org>> wrote:
> PGAdmin Version 1.12.2 (Dec 13 2010, REL-1_12_2)
>
> Workstation - Windows XP x64 SP2
>
>
>
> When I right click on a *.sql file in Windows Explorer and select Open With
> pgAdmin III the splash screen is shown followed by the login box. After
> making login box selections, I receive an error window stating “pgAdmin III
> – Postgres SQL Tools has encountered a problem and needs to close. We are
> sorry for the inconvenience.”
>
>
>
> I am able to open and utilize pgAdmin from the start menu and open *.sql
> files from the file>open in the sql tool.
>
>
>
>
>
>
>
> Russell Galyon
>
> ________________________________
> The information contained in this Email message is private and confidential.
> It may contain Protected Health Information deemed confidential by HIPAA
> regulations. It is intended only for the use of the individual(s) named
> above, and the privileges are not waived by virtue of this information
> having been sent by Email. Any use, dissemination, distribution or copying
> of this the information contained in this communication is strictly
> prohibited by anyone except the named individual or that person's agent. If
> you have received this Email in error, please notify the sender immediately
> and destroy this Email. Thank You.
>



--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


The information contained in this Email message is private and confidential. It may contain Protected Health
Informationdeemed confidential by HIPAA regulations. It is intended only for the use of the individual(s) named above,
andthe privileges are not waived by virtue of this information having been sent by Email. Any use, dissemination,
distributionor copying of this the information contained in this communication is strictly prohibited by anyone except
thenamed individual or that person's agent. If you have received this Email in error, please notify the sender
immediatelyand destroy this Email. Thank You. 

Le 10/01/2011 16:21, Dhiraj Chawla a écrit :
> Hi Dave,
>
> I was able to reproduce the issue. Please find attached patches for master
> and REL_1_12_PATCHES branches.
>

Oh, clever. If the query tool is opened from a file, there is no
browser, meaning mainForm is NULL.

Good catch.

Thanks, Dhiraj.


--
Guillaume
 http://www.postgresql.fr
 http://dalibo.com

On Mon, Jan 10, 2011 at 3:38 PM, Guillaume Lelarge
<guillaume@lelarge.info> wrote:
> Le 10/01/2011 16:21, Dhiraj Chawla a écrit :
>> Hi Dave,
>>
>> I was able to reproduce the issue. Please find attached patches for master
>> and REL_1_12_PATCHES branches.
>>
>
> Oh, clever. If the query tool is opened from a file, there is no
> browser, meaning mainForm is NULL.
>
> Good catch.
>
> Thanks, Dhiraj.

Yes - thanks Dhiraj. Patch applied to both trunk, and the 1.12 branch.

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company