Hi developers!

Testing pgAdmin v.1.8.2 (Feb 5 2008), rev: 7050) on WinXP; host: pg 8.2.6 on Debian Etch


Congrats on 1.8.2, guys! Better late than never. :) (My congratulations, not the release, mind you!) Upgrading was smooth, it works (mostly) stable. I do get occasional crashes, but I cannot connect them to a specific cause.


I was able to pin down another (minor) issue, which I'll report instead. In today´s bug report I'd like to return to a classic: editing text in the table grid under windows.

To see my point you might want to just reproduce the bug. Create an email hyperlink in an OOo document. (Insert -> Hyperlink ..) Then copy/paste the email-address to a text field in the table grid.

As long as you are in edit mode, the field displays (in blue, so obviously something is different):
        [EMAIL PROTECTED]

As soon as you leave the field, to another column or row, saving the data or not, the display changes to:
        HYPERLINK "mailto:[EMAIL PROTECTED]" [EMAIL PROTECTED]

If you re-enter the field, the text switches back to:
        [EMAIL PROTECTED]

No chance to get rid of the markup. Only if you enter edit mode in same field in another tuple, with _different_ content (markup or not), the behavior switches back to normal and you can edit what you see. Took me some time to discern that from mere randomness.

I checked in psql an pgadmin with SELECT '|' || foo || '|' from bar;
No additional characters, just
        HYPERLINK "mailto:[EMAIL PROTECTED]" [EMAIL PROTECTED]

You can even reactivate the unwelcome behavior by entering the _same_ prepared email-address in the same field of another tuple. Then you cannot edit the markup-part of either field in the column with same content, until fixed as above.


This might shares roots with the pesky (well-known) bug that gives us additional newlines when copying field values: the windows rich-text (?) control does not always talk straight with the rest of the application.
So, not sure if you can do something about that.


Regards
Erwin

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

               http://www.postgresql.org/about/donate

Reply via email to