Re: SQL pane freezes while editing

On 07/27/2012 07:14 AM, Michael Shapiro wrote:
> Works fine for me.
>
> I am running PgAdmin 1.14.2 Under Window 7 SP 1.
>
> On Fri, Jul 27, 2012 at 4:59 AM, Colin Beckingham <colbec@start.ca
> <mailto:colbec@start.ca>> wrote:
>
>
>
>     On 07/27/2012 05:04 AM, Michael Shapiro wrote:
>
>         I tried this and could not replicate the behavior
>         The SQL is used looked like
>
>             select * from x
>            where (g = 5
>              and   h =6
>              and y = 7)
>
>         without word wrap there is a scroll bar
>         with word wrap there is no scrollbar
>
>         I was able to remove the left parenthesis and put it back
>         without any
>         problems under both word wrap settings.
>
>
>         On Fri, Jul 27, 2012 at 3:14 AM, Colin Beckingham
>         <colbec@start.ca <mailto:colbec@start.ca>
>         <mailto:colbec@start.ca <mailto:colbec@start.ca>>> wrote:
>
>              Dev 1.17, wxwidgets 2.9.3
>
>              Some time ago I reported that my pgadmin SQL editor showed
>         freeze
>              behaviour under certain conditions:
>              multiple SQL lines
>              containing parentheses
>              remove one left parenthesis, then try to put it back,
>              pane freezes, with or without disappearance of text
>              replaced by a light blue background
>              freeze can be removed by using mouse to drag horizontal
>         slider forth
>              and back.
>
>              This appears to be related to the 'word wrap' setting.
>              Default editor word wrap setting is off.
>              Using word wrap off, above behaviour is observed.
>              Switch word wrap on, behaviour is not observed.
>              Anyone else see this?
>              --
>              ---
>              Colin Beckingham
>         613-454-5369 <tel:613-454-5369> <tel:613-454-5369
>         <tel:613-454-5369>>
>         http://www.it4gh.com
>
>              --
>              Sent via pgadmin-support mailing list
>              (pgadmin-support@postgresql.____org
>              <mailto:pgadmin-support@__postgresql.org
>         <mailto:pgadmin-support@postgresql.org>>)
>              To make changes to your subscription:
>         http://www.postgresql.org/____mailpref/pgadmin-support
>         <http://www.postgresql.org/__mailpref/pgadmin-support>
>              <http://www.postgresql.org/__mailpref/pgadmin-support
>         <http://www.postgresql.org/mailpref/pgadmin-support>>
>
>
>
>     Thanks for your input.
>     Agreed, your example works correctly under both settings.
>
>     Please try the following SQL as a text example.
>     Switch on line numbers in the editor, you should find left parens
>     on lines 8,9,10,13 and 26.
>     In my editor, with word wrap off, any attempt to edit 8 through 13
>     left parenthesis, ie, remove it and put it back
>     results in sluggish keyboard, vertical bar cursor stops flashing
>     and mouse fails to move cursor until I drag the slider.
>     Editing left paren on line 26 is fine.
>     -------------------
>
>     CREATE TABLE inspbox
>     (
>        ibid serial NOT NULL,
>        icid integer,
>        "position" smallint,
>        fbcount smallint,
>        fecount smallint,
>        CONSTRAINT inspbox_pkey PRIMARY KEY (ibid ),
>        CONSTRAINT fk2 FOREIGN KEY (icid)
>            REFERENCES inspcol (icid) MATCH SIMPLE
>            ON UPDATE NO ACTION ON DELETE NO ACTION
>     )
>     WITH (
>        OIDS=FALSE
>     );
>     ALTER TABLE inspbox
>        OWNER TO colin;
>
>     -- Index: inspbox.fki_fk2
>
>     -- DROP INDEX inspbox.fki_fk2;
>
>     CREATE INDEX fki_fk2
>        ON inspbox
>        USING btree
>        (icid );
>     ------------------
>

Okay, thanks. So the issue continues to be system specific.

At least the word wrap thing is a convenient workaround which comes at 
little to no cost.

-- 
---
Colin Beckingham
613-454-5369
http://www.it4gh.com