Re: Freeze when trying to run a pg_dump backup file as SQL query

On 13/07/2012 16:26, Evan Martin wrote:
> No comments at all? Can anyone else at least repro this?
>
> On 6/07/2012 10:33 PM, Evan Martin wrote:
>> 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

Is there anything at all happening with pgAdmin while the query is
running? Is the timer in the lower right corner of the window incrementing?

You probably know this, but just in case: plain-text backup files from
pg_dump don't as a rule work in a pgAdmin query window, as they contain
various psql-specific backslash commands that pgAdmin doesn't handle;
pipe the file to psql instead. pgAdmin does, however, handle
binary-format pg_dump files; select "restore" from a right-click menu in
the tree view.

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie