Re: SQL pane freezes while editing

On Fri, 2012-07-27 at 07:39 -0400, Colin Beckingham wrote:
> 
> 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.
> 

I uppose Michael isn't using 2.9 release of wxWidgets. Your issue may be
more related to this than to the system.


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com