Freeze when trying to run a pg_dump backup file as SQL query - Mailing list pgadmin-support

From Evan Martin
Subject Freeze when trying to run a pg_dump backup file as SQL query
Date
Msg-id 4FF6DB0A.1060101@realityexists.net
Whole thread Raw
Responses Re: Freeze when trying to run a pg_dump backup file as SQL query
List pgadmin-support
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/BLAH/BLAH/BLAH/BLAH/BLAH/BLAH/BLAH/BLAH
BLAH/BLAH/BLAH/BLAH/BLAH/BLAH/BLAH/BLAH/BLAH/BLAH/BLAH/BLAH/BLAH
BLAH/BLAH/BLAH/BLAH/BLAH/BLAH/BLAH/BLAH/BLAH/BLAH/BLAH/BLAH/BLAH
BLAH/BLAH/BLAH/BLAH/BLAH/BLAH/BLAH/BLAH/BLAH/BLAH/BLAH/BLAH/BLAH
BLAH/BLAH/BLAH/BLAH/BLAH/BLAH/BLAH/BLAH/BLAH/BLAH/BLAH/BLAH/BLAH
\.

When I run that the output window shows:

ERROR:  syntax error at or near "BLAH"
LINE 2: BLAH/BLAH/BLAH/BLAH/BLAH/BLAH/BLAH/BLAH/BLAH/BLAH/BLAH/BLAH/...

That's fine (well, it would be nice if pgAdmin supported restoring such 
files, but that's another story) - but then it freezes. It doesn't 
happen with 5 lines as above, but if I have 100 lines of data that's 
enough to make it freeze for a few seconds. With a real back-up file of 
1 MB or more it probably won't come back any time soon and has to be 
killed. (It doesn't need to be real data - just copy/paste the 5 BLAH 
lines above 20 times to reproduce the problem.)

I'm running pgAdmin 1.14.3 running on Windows 7 (x64), PostgreSQL 9.1.3

Regards,

Evan


pgadmin-support by date:

Previous
From: Dave Page
Date:
Subject: Re: pgAgent reports failure upon success
Next
From: Michael Shapiro
Date:
Subject: background process?