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 <col...@start.ca
<mailto: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>
<mailto: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> <tel: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
<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>
<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
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
