Re: SQL pane freezes while editing

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(at)start(dot)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(at)start(dot)ca
>> <mailto:colbec(at)start(dot)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(at)postgresql(dot)__**org
>> <mailto:pgadmin-support(at)**postgresql(dot)org<pgadmin-support(at)postgresql(dot)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
>