Thread: SQL Query Pane bug

Hi,<br clear="all" /><br />I'm running Version 1.8.4, r7358 on Ubuntu 8.10.<br /><br />When I hit the 'SQL Query'
button,the window shows 'File', 'Edit', 'Query' etc.,  but the internal pane is blank.<br /> I've tried reinstalling
andchecked pgadmin.log but found nothing.<br /><br />Thanks,<br /><br />Eoghan<br /> 

On Mon, Mar 2, 2009 at 8:26 AM, Eoghan Murray <eoghan@getthere.ie> wrote:
> Hi,
>
> I'm running Version 1.8.4, r7358 on Ubuntu 8.10.
>
> When I hit the 'SQL Query' button, the window shows 'File', 'Edit', 'Query'
> etc.,  but the internal pane is blank.
> I've tried reinstalling and checked pgadmin.log but found nothing.

What were you expecting to see, the query from the main form? If so,
see File -> Options -> Query -> 'Copy SQL from main form to SQL
dialogue'.

If something else, please explain :-)

--
Dave Page
EnterpriseDB UK:   http://www.enterprisedb.com

On Mon, Mar 2, 2009 at 11:16 AM, Eoghan Murray <eoghan@getthere.ie> wrote:
> Hi,
>
> Sorry, I'll elaborate: there is no editable textarea present so you can't
> type anything in.
> http://img79.imageshack.us/img79/2356/querypane.png
> This happens independently of the context (database selected/table selected)
> or how I get to the window (Click the  button with the tooltip 'Execute
> Arbitrary SQL Queries' as well as Tools -> Query Tool menu item)

Ahh - try selecting View -> Default View. It sounds like your window
layout got messed up somehow.


--
Dave Page
EnterpriseDB UK:   http://www.enterprisedb.com

Hi,

Sorry, I'll elaborate: there is no editable textarea present so you can't type anything in.
http://img79.imageshack.us/img79/2356/querypane.png
This happens independently of the context (database selected/table selected) or how I get to the window (Click the  button with the tooltip 'Execute Arbitrary SQL Queries' as well as Tools -> Query Tool menu item)

Eoghan




--
+353 86 236 1190
http://www.linkedin.com/in/eoghanmurray

On Mon, Mar 2, 2009 at 12:45 PM, Eoghan Murray <eoghan@getthere.ie> wrote:
>
>> Ahh - try selecting View -> Default View. It sounds like your window
>> layout got messed up somehow.
>
> Thanks, but no change in behaviour after doing that.

Odd. Try removing (renaming) your preferences file (~/.pgadmin3) and
then start pgAdmin

> One extra clue: for the last few months normally invisible newlines in the
> sql pane have shown up with a funny character glyph.  Might not be related
> at all.

Perhaps you turned on View Line Ends?



--
Dave Page
EnterpriseDB UK:   http://www.enterprisedb.com

On Mon, Mar 2, 2009 at 2:11 PM, Eoghan Murray <eoghan@getthere.ie> wrote:

> Great! Both problems fixed now that I removed the preference file.

Excellent.

> FWIW here is a before and after of the relevant section... I haven't been
> able to narrow down the problem any more than this... maybe it's the
> duplicate perspective entry?

No - that's normal (if the code changes, we use a new setting).


-- 
Dave Page
EnterpriseDB UK:   http://www.enterprisedb.com

2009/3/2 Dave Page <dpage@pgadmin.org>