Re: SQL pane freezes while editing - Mailing list pgadmin-support
From | Michael Shapiro |
---|---|
Subject | Re: SQL pane freezes while editing |
Date | |
Msg-id | CAGCvxebvd+5USBfppHZa9hLE=Y5KoBF8Ff67Vo53t5tV3yCHMg@mail.gmail.com Whole thread Raw |
In response to | Re: SQL pane freezes while editing (Colin Beckingham <colbec@start.ca>) |
Responses |
Re: SQL pane freezes while editing
|
List | pgadmin-support |
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 />
pgadmin-support by date: