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 <col...@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 <col...@start.ca >> <mailto:col...@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<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 ); > ------------------ > > -- > --- > Colin Beckingham > 613-454-5369 > http://www.it4gh.com >
