Re: [pgadmin-hackers] Fwd: Filter by Selection on Grid

2008-02-11 Thread Dave Page
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

2008-02-11 Thread Dave Page
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

2008-02-11 Thread svn
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

2008-02-11 Thread svn
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

2008-02-11 Thread svn
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

2008-02-11 Thread Dave Page
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

2008-02-11 Thread svn
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