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

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.

Dhiraj,

Can you take a look at this issue please?

Thanks!

On Tue, Jan 4, 2011 at 10:37 PM, Russell L. Galyon
<Russell(dot)Galyon(at)centerstoneresearch(dot)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

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? If so can you share information
about that with us?

Regards,
Dhiraj

On Thu, Jan 6, 2011 at 3:55 PM, Dave Page <dpage(at)pgadmin(dot)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(dot)Galyon(at)centerstoneresearch(dot)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 (Windows Vista, 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 policy our virus protection. Has anyone had issues with specific policy settings or Sophos?
________________________________________
From: Dhiraj Chawla [dhiraj(dot)chawla(at)enterprisedb(dot)com]
Sent: Monday, January 10, 2011 1:52 AM
To: Russell L. Galyon
Cc: pgadmin-support(at)postgresql(dot)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? If so can you share information about that with us?

Regards,
Dhiraj

On Thu, Jan 6, 2011 at 3:55 PM, Dave Page <dpage(at)pgadmin(dot)org<mailto:dpage(at)pgadmin(dot)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(dot)Galyon(at)centerstoneresearch(dot)org<mailto:Russell(dot)Galyon(at)centerstoneresearch(dot)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 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.

Hi Dave,

I was able to reproduce the issue. Please find attached patches for master
and REL_1_12_PATCHES branches.

Thanks,
Dhiraj

On Mon, Jan 10, 2011 at 6:49 PM, Russell L. Galyon <
Russell(dot)Galyon(at)centerstoneresearch(dot)org> wrote:

> Nothing is wrong with my associations that I am aware of (Windows XP x64,
> Sophos). I tried this on a co-workers pc (Windows Vista, 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 policy our virus
> protection. Has anyone had issues with specific policy settings or Sophos?
> ________________________________________
> From: Dhiraj Chawla [dhiraj(dot)chawla(at)enterprisedb(dot)com]
> Sent: Monday, January 10, 2011 1:52 AM
> To: Russell L. Galyon
> Cc: pgadmin-support(at)postgresql(dot)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? If so can you share information
> about that with us?
>
> Regards,
> Dhiraj
>
> On Thu, Jan 6, 2011 at 3:55 PM, Dave Page <dpage(at)pgadmin(dot)org<mailto:
> dpage(at)pgadmin(dot)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(dot)Galyon(at)centerstoneresearch(dot)org<mailto:
> Russell(dot)Galyon(at)centerstoneresearch(dot)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 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.
>

--
regards,
Dhiraj

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(at)lelarge(dot)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