[pgadmin-support] Freeze when trying to run a pg_dump backup file as SQL query

2012-07-06 Thread Evan Martin
I've reliably reproduced the freezing bug I mentioned before (in the suggestion to save query text). pgAdmin freezes when I try to run a backup file created by pg_dump from an SQL query window. The file contents look like this: COPY much_data (some_data) FROM stdin; BLAH/BLAH/BLAH/BLAH/BLAH/BL

Re: [pgadmin-support] pgAgent reports failure upon success

2012-07-06 Thread Dave Page
On Fri, Jul 6, 2012 at 12:26 PM, Martin French wrote: > Yep, can do, and will do Dave. > > Will be after the weekend now, but should have something Monday eve. > Great. > Have a good weekend mate. > > Cheers > And you! Cheers, Dave. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pg

Re: [pgadmin-support] pgAgent reports failure upon success

2012-07-06 Thread Martin French
Yep, can do, and will do Dave.Will be after the weekend now, but should have something Monday eve.Have a good weekend mate.CheersDave Page ---06/07/2012 12:22:56---Hi On Fri, Jul 6, 2012 at 11:36 AM, Martin FrenchFrom:Dave Page To:Martin French , Cc:pgadmin-support@postgresq

Re: [pgadmin-support] pgAgent reports failure upon success

2012-07-06 Thread Dave Page
Hi On Fri, Jul 6, 2012 at 11:36 AM, Martin French wrote: > Hi Dave, > > That seems reasonable enough to me. > > GetLastError only returns a wxString though, fed from PQerrorMessage so I > guess it would be the string that would be tested for content? > > Maybe passing the ExecStatusType into a DB

Re: [pgadmin-support] Posgres 9.1.4

2012-07-06 Thread Craig Ringer
On 07/06/2012 05:14 PM, Vision Software Solutions wrote: Dear sir We are using postgres 9.1.4 as our database to all software development project. When we try to install on the windows 2000 advance server we are getting an error during the installation as "Unknown Error executing pre installat

Re: [pgadmin-support] pgAgent reports failure upon success

2012-07-06 Thread Martin French
Hi Dave,That seems reasonable enough to me. GetLastError only returns a wxString though, fed from PQerrorMessage so I guess it would be the string that would be tested for content?Maybe passing the ExecStatusType into a DBConn/DBResult member variable that could be tested would work better?Thoughts

Re: [pgadmin-support] pgAgent reports failure upon success

2012-07-06 Thread Dave Page
Hi On Fri, Jul 6, 2012 at 8:04 AM, Martin French wrote: > > I've been through the code, and the return of 1 is coming back from the > number of rows inserted after ExecuteVoid so the logic following in job.cpp > seems incorrect: > > wxString stepstatus; > if (rc ==

Re: [pgadmin-support] Posgres 9.1.4

2012-07-06 Thread Dave Page
Hi On Fri, Jul 6, 2012 at 10:14 AM, Vision Software Solutions wrote: > Dear sir > > We are using postgres 9.1.4 as our database to all software development > project. When we try to install on the windows 2000 advance server we are > getting an error during the installation as "Unknown Error exec

[pgadmin-support] Posgres 9.1.4

2012-07-06 Thread Vision Software Solutions
Dear sir We are using postgres 9.1.4 as our database to all software development project. When we try to install on the windows 2000 advance server we are getting an error during the installation as "Unknown Error executing pre installation actions" Service pack 4 has been already setup on the

[pgadmin-support] pgAgent reports failure upon success

2012-07-06 Thread Martin French
pgAgent is reporting that the job running this query:insert into dba.pg_stat_bgwriter_data(select *, now() from pg_catalog.pg_stat_bgwriter);is failing with a return code of 1, despite having completed the insert ok.When I wrap the code in a "do" statement, it report