Re: SQL pane freezes while editing

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 />