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