Re: SQL pane freezes while editing

On 07/27/2012 07:14 AM, Michael Shapiro wrote:
> 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
> <mailto: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>
> <mailto: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> <tel: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
> <mailto: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 );
> ------------------
>

Okay, thanks. So the issue continues to be system specific.

At least the word wrap thing is a convenient workaround which comes at
little to no cost.

--
---
Colin Beckingham
613-454-5369
http://www.it4gh.com