Thread: SQL pane freezes while editing
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 http://www.it4gh.com
I tried this and could not replicate the behavior<br />The SQL is used looked like<br /> <br /> select * from x<br /> where(g = 5<br /> and h =6<br /> and y = 7)<br /><br />without word wrap there is a scroll bar <br />with word wrapthere is no scrollbar<br /><br />I was able to remove the left parenthesis and put it back without any problems underboth word wrap settings.<br /><br /><br /><div class="gmail_quote">On Fri, Jul 27, 2012 at 3:14 AM, Colin Beckingham<span dir="ltr"><<a href="mailto:colbec@start.ca" target="_blank">colbec@start.ca</a>></span> wrote:<br /><blockquoteclass="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Dev 1.17, wxwidgets2.9.3<br /><br /> Some time ago I reported that my pgadmin SQL editor showed freeze behaviour under certain conditions:<br/> multiple SQL lines<br /> containing parentheses<br /> remove one left parenthesis, then try to put it back,<br/> pane freezes, with or without disappearance of text<br /> replaced by a light blue background<br /> freeze canbe removed by using mouse to drag horizontal slider forth and back.<br /><br /> This appears to be related to the 'wordwrap' setting.<br /> Default editor word wrap setting is off.<br /> Using word wrap off, above behaviour is observed.<br/> Switch word wrap on, behaviour is not observed.<br /> Anyone else see this?<span class="HOEnZb"><font color="#888888"><br/> -- <br /> ---<br /> Colin Beckingham<br /><a href="tel:613-454-5369" target="_blank" value="+16134545369">613-454-5369</a><br/><a href="http://www.it4gh.com" target="_blank">http://www.it4gh.com</a><br /><br/> -- <br /> Sent via pgadmin-support mailing list (<a href="mailto:pgadmin-support@postgresql.org" target="_blank">pgadmin-support@postgresql.<u></u>org</a>)<br/> To make changes to your subscription:<br /><a href="http://www.postgresql.org/mailpref/pgadmin-support" target="_blank">http://www.postgresql.org/<u></u>mailpref/pgadmin-support</a><br/></font></span></blockquote></div><br />
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>> 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> > http://www.it4gh.com > > -- > Sent via pgadmin-support mailing list > (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> > > 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_pkeyPRIMARY KEY (ibid ), CONSTRAINT fk2 FOREIGN KEY (icid) REFERENCES inspcol (icid) MATCH SIMPLE ON UPDATENO 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 ); ------------------ -- --- Colin Beckingham 613-454-5369 http://www.it4gh.com
Works fine for me.<br /><br />I am running PgAdmin 1.14.2 Under Window 7 SP 1.<br /><br /><div class="gmail_quote">On Fri,Jul 27, 2012 at 4:59 AM, Colin Beckingham <span dir="ltr"><<a href="mailto:colbec@start.ca" target="_blank">colbec@start.ca</a>></span>wrote:<br /><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px#ccc solid;padding-left:1ex"><br /><br /> On 07/27/2012 05:04 AM, Michael Shapiro wrote:<br /><blockquoteclass="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"> I tried this andcould not replicate the behavior<br /> The SQL is used looked like<br /><br /> select * from x<br /> where (g = 5<br/> and h =6<br /> and y = 7)<br /><br /> without word wrap there is a scroll bar<br /> with word wrap thereis no scrollbar<br /><br /> I was able to remove the left parenthesis and put it back without any<br /> problems underboth word wrap settings.<br /><br /><br /> On Fri, Jul 27, 2012 at 3:14 AM, Colin Beckingham <<a href="mailto:colbec@start.ca"target="_blank">colbec@start.ca</a><br /> <mailto:<a href="mailto:colbec@start.ca" target="_blank">colbec@start.ca</a>>>wrote:<br /><br /> Dev 1.17, wxwidgets 2.9.3<br /><br /> Some time agoI reported that my pgadmin SQL editor showed freeze<br /> behaviour under certain conditions:<br /> multiple SQLlines<br /> containing parentheses<br /> remove one left parenthesis, then try to put it back,<br /> panefreezes, with or without disappearance of text<br /> replaced by a light blue background<br /> freeze can beremoved by using mouse to drag horizontal slider forth<br /> and back.<br /><br /> This appears to be related tothe 'word wrap' setting.<br /> Default editor word wrap setting is off.<br /> Using word wrap off, above behaviouris observed.<br /> Switch word wrap on, behaviour is not observed.<br /> Anyone else see this?<br /> --<br /> ---<br /> Colin Beckingham<br /> <a href="tel:613-454-5369" target="_blank" value="+16134545369">613-454-5369</a><tel:<a href="tel:613-454-5369" target="_blank" value="+16134545369">613-454-5369</a>><br/> <a href="http://www.it4gh.com" target="_blank">http://www.it4gh.com</a><br/><br /> --<br /> Sent via pgadmin-support mailing list<br /> (pgadmin-support@postgresql.__<u></u>org<br/> <mailto:<a href="mailto:pgadmin-support@postgresql.org" target="_blank">pgadmin-support@<u></u>postgresql.org</a>>)<br/> To make changes to your subscription:<br /> <ahref="http://www.postgresql.org/__mailpref/pgadmin-support" target="_blank">http://www.postgresql.org/__<u></u>mailpref/pgadmin-support</a><br/> <<a href="http://www.postgresql.org/mailpref/pgadmin-support" target="_blank">http://www.postgresql.org/<u></u>mailpref/pgadmin-support</a>><br/><br /><br /></blockquote><br /> Thanksfor your input.<br /> Agreed, your example works correctly under both settings.<br /><br /> Please try the followingSQL as a text example.<br /> Switch on line numbers in the editor, you should find left parens<br /> on lines 8,9,10,13and 26.<br /> In my editor, with word wrap off, any attempt to edit 8 through 13<br /> left parenthesis, ie, removeit and put it back<br /> results in sluggish keyboard, vertical bar cursor stops flashing<br /> and mouse fails tomove cursor until I drag the slider.<br /> Editing left paren on line 26 is fine.<br /> -------------------<br /><br />CREATE TABLE inspbox<br /> (<br /> ibid serial NOT NULL,<br /> icid integer,<br /> "position" smallint,<br /> fbcountsmallint,<br /> fecount smallint,<br /> CONSTRAINT inspbox_pkey PRIMARY KEY (ibid ),<br /> CONSTRAINT fk2 FOREIGNKEY (icid)<br /> REFERENCES inspcol (icid) MATCH SIMPLE<br /> ON UPDATE NO ACTION ON DELETE NO ACTION<br/> )<br /> WITH (<br /> OIDS=FALSE<br /> );<br /> ALTER TABLE inspbox<br /> OWNER TO colin;<br /><br /> -- Index:inspbox.fki_fk2<br /><br /> -- DROP INDEX inspbox.fki_fk2;<br /><br /> CREATE INDEX fki_fk2<br /> ON inspbox<br /> USING btree<br /> (icid );<br /> ------------------<span class="HOEnZb"><font color="#888888"><br /><br /> -- <br />---<br /> Colin Beckingham<br /><a href="tel:613-454-5369" target="_blank" value="+16134545369">613-454-5369</a><br /><ahref="http://www.it4gh.com" target="_blank">http://www.it4gh.com</a><br /></font></span></blockquote></div><br />
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
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
How do I determine which version of wxWidgets are being used?<br /><br /><div class="gmail_quote">On Fri, Jul 27, 2012 at6:53 AM, Guillaume Lelarge <span dir="ltr"><<a href="mailto:guillaume@lelarge.info" target="_blank">guillaume@lelarge.info</a>></span>wrote:<br /><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px#ccc solid;padding-left:1ex"><div class="HOEnZb"><div class="h5">On Fri, 2012-07-27 at 07:39 -0400, ColinBeckingham wrote:<br /><br /><br /></div></div>I suppose Michael isn't using 2.9 release of wxWidgets. Your issue maybe<br /> more related to this than to the system.<br /><span class="HOEnZb"><font color="#888888"><br /><br /> --<br />Guillaume<br /><a href="http://blog.guillaume.lelarge.info" target="_blank">http://blog.guillaume.lelarge.info</a><br /><ahref="http://www.dalibo.com" target="_blank">http://www.dalibo.com</a><br /><br /></font></span></blockquote></div><br/>
On Fri, 2012-07-27 at 07:29 -0500, Michael Shapiro wrote: > How do I determine which version of wxWidgets are being used? > Quickly, if you don't know, you're using 2.8, just like (100% - 1) persons in the world :) If you didn't compile it yourself (which means also compiling wxWidgets), then you're using 2.8 release. Otherwise, you may be using 2.9 but you must know because you had to download wxWidgets source files to compile them. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com