Re: [pgadmin-hackers] Fwd: Filter by Selection on Grid
On Feb 10, 2008 3:47 PM, Robins Tharakan <[EMAIL PROTECTED]> wrote: > > As promised, here are two other patches, one each for the following: > > > 1. IS DISTINCT FROM to replace '<>' in the WHERE conditions > 2. Documentation addition in the html about the recent Selection/Sort > changes. Thanks - patches applied! -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com The Oracle-compatible database company ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [pgadmin-hackers] Formatted text confuses table grid under windows
Hi Erwin, On Feb 9, 2008 2:56 AM, Erwin Brandstetter <[EMAIL PROTECTED]> wrote: > 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'm sure you'll let us know if you ever figure it out! > 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. Grrr. > 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] > Unfortunately I cannot find any way around this. If we stop using the rich text control, we limit the amount of data we can handle as the non-rich text variant will simply truncate oversized data on win32. There is no way in wxWidgets to remove the URL formatting that I can find, nor is there any way offered by the rich text controls own API :-(. It is somewhat odd that we can get the text with the other formatting (font etc) though - perhaps an overisght on Microsoft's behalf? The only other option I can see is to rewrite the grid text editor to use the styled text control, but that will be some work. I'll add a TODO for it though. Cheers, Dave -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com The Oracle-compatible database company ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[pgadmin-hackers] SVN Commit by dpage: r7072 - trunk/pgadmin3/docs/en_US
Author: dpage Date: 2008-02-11 11:52:47 + (Mon, 11 Feb 2008) New Revision: 7072 Revision summary: http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/?rev=7072&view=rev Log: Document the edit grid sort/filter options [Robins Tharakan] Modified: trunk/pgadmin3/docs/en_US/editgrid.html ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[pgadmin-hackers] SVN Commit by dpage: r7070 - trunk/pgadmin3/pgadmin/frm
Author: dpage Date: 2008-02-11 11:32:59 + (Mon, 11 Feb 2008) New Revision: 7070 Revision summary: http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/?rev=7070&view=rev Log: When using quick-sorting in the edit grid, update existing column sorts rather than blindly adding to them [Robins Tharakan] Modified: trunk/pgadmin3/pgadmin/frm/frmEditGrid.cpp ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
[pgadmin-hackers] SVN Commit by dpage: r7073 - trunk/pgadmin3
Author: dpage Date: 2008-02-11 21:17:35 + (Mon, 11 Feb 2008) New Revision: 7073 Revision summary: http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/?rev=7073&view=rev Log: Add a todo. Modified: trunk/pgadmin3/TODO ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [pgadmin-hackers] Fwd: Filter by Selection on Grid
On Feb 9, 2008 6:52 PM, Robins Tharakan <[EMAIL PROTECTED]> wrote: > Hi, > > Hmmm... although I did do a complete svn co before submitting my previous > patch, I think I am making it all complicated by bringing in too many things > together. > > I think you're right. Probably its better to do one thing at a time :) > > Attached is a patch to correct the Sort issue. It does an in-place string > replace if the sort order is changed by the user. > Thanks, patch applied! -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com The Oracle-compatible database company ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[pgadmin-hackers] SVN Commit by dpage: r7071 - trunk/pgadmin3/pgadmin/frm
Author: dpage Date: 2008-02-11 11:47:17 + (Mon, 11 Feb 2008) New Revision: 7071 Revision summary: http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/?rev=7071&view=rev Log: Use IS DISTINCT FROM in exclusion filters in the edit grid [Robins Tharakan] Modified: trunk/pgadmin3/pgadmin/frm/frmEditGrid.cpp ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate