[pgadmin-hackers] Admin4 - anybody interested?

2014-06-06 Thread Andreas Pflug
Hi Folks, long time no hear! And well, this is a one-time only contact, I'm not going to re-join the pgAdmin community (not even subscribed to the list). The intention of my mail is to bring Admin4 ( http://www.admin4.org ) to your attention, maybe show new perspectives and eventually attract

Re: [pgadmin-hackers] pgAdmin licence

2007-10-15 Thread Andreas Pflug
Dave Page wrote: My offer to get and review my changes in order to extract them for the official pgAdmin never got an answer. I honestly never received such an email, and would have been glad to accept had I done. As for leaving the team, you unsubscribed from all the mailing lists

Re: [pgadmin-hackers] pgAdmin licence

2007-10-14 Thread Andreas Pflug
Dave Page wrote: Andreas Pflug wrote: Dave whatsup? I'm trying to do three things (in no particular order): 1) Change the pgAdmin licence to Artistic 2.0 and above. You are the only developer who has refused permission to do that, however that is your right and we will respect

Re: [pgadmin-hackers] pgAdmin licence

2007-10-13 Thread Andreas Pflug
Dave Page wrote: --- Original Message --- From: Andreas Pflug [EMAIL PROTECTED] To: Dave Page [EMAIL PROTECTED] Sent: 12/10/07, 22:11:36 Subject: Re: pgAdmin licence Dave, since pgImport was originally written to import from file to MSSQL, with pgsql support added later

Re: [pgadmin-hackers] pgAdmin licence

2007-10-12 Thread Andreas Pflug
Dave Page wrote: Andreas Pflug wrote: No. You removed VC6 support, which was absolutely vital for me, without ever asking whether that was viable. Since my development was tightly integrated, I wasn't able to switch one of projects separately (at least in the timeframe available

Re: [pgadmin-hackers] pgAdmin licence

2007-10-11 Thread Andreas Pflug
Dave Page wrote: This email has been sent to you because our records indicate that at some point in the past you have contributed to the pgAdmin III project (http://www.pgadmin.org). It this is not the case, please let me know as soon as possible. Since it was first released, pgAdmin III has

Re: [pgadmin-hackers] pgAdmin licence

2007-10-11 Thread Andreas Pflug
Dave Page wrote: Andreas Pflug wrote: for me the worst case already happened last year, when I had to fork my own code to continue my job. As a consequence, I won't give away control over sources any more for tools I release to the public, such as www.pse-consulting.de/pg/pgImport.zip

Re: [pgadmin-hackers] SVN Commit by dpage: r5179 - in trunk/pgadmin3:

2006-05-23 Thread Andreas Pflug
Dave Page wrote: - I reviewed the patch and found it to be of good quality, restoring the broken functionality, without breaking your speed improvements. I applied the patch. To me, *your* patch broke the source. You removed the code I insisted to retain until the other stuff is completely

Re: [pgadmin-hackers] CHANGELOG

2006-05-01 Thread Andreas Pflug
Dave Page wrote: Hi, I added the version number back into all the changelog entires that you removed them from. We know what the version number will be so it makes no sense not to include it now and save me 10 minutes of post-release editting later on. Um, until 1.4 we didn't fill the

Re: [pgadmin-hackers] SVN Commit by dpage: r5106 - in trunk/pgadmin3:

2006-05-01 Thread Andreas Pflug
[EMAIL PROTECTED] wrote: Author: dpage Date: 2006-04-30 21:13:00 +0100 (Sun, 30 Apr 2006) New Revision: 5106 Revision summary: http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/?rev=5106view=rev Log: Pre-encrypt passwords before sending them down the wire or displaying them in SQL statements. Is

Re: [pgadmin-hackers] Reporting

2006-05-01 Thread Andreas Pflug
Dave Page wrote: Right, let me give you a quick rundown on whats /currently/ there as this may affect how things can potentially work with the factories. - pgObject and each derived class return a report menu for the current object using GetReportMenu (in pgObject) and GetObjectReportMenu (in

Re: [pgadmin-hackers] SVN Commit by dpage: r5106 - in trunk/pgadmin3:

2006-05-01 Thread Andreas Pflug
Dave Page wrote: I considered this carefully and chose that method for a few reasons. 'k, after having a look what you did a I found you copied the backend's version. I agree with your arguments. AFAICS this is basically a plain copy of the backend version? If so, I'd prefer to have it

Re: [pgadmin-hackers] CHANGELOG

2006-05-01 Thread Andreas Pflug
Dave Page wrote: -Original Message- From: Andreas Pflug[EMAIL PROTECTED] Sent: 01/05/06 11:41:59 To: Dave Pagedpage@vale-housing.co.uk Cc: pgadmin-hackers@postgresql.orgpgadmin-hackers@postgresql.org Subject: Re: CHANGELOG Um, until 1.4 we didn't fill the version number until we

Re: [pgadmin-hackers] SVN Commit by dpage: r5106 - in trunk/pgadmin3:

2006-05-01 Thread Andreas Pflug
Dave Page wrote: md5.c(pp) is unchanged, bar the top comment. md5.h is custom though. I have no problem moving them. Well, thinking again it appears that different from keywords.c md5.c(pp) won't be subject to regular change. So let's leave it as it is now, rollback my previous remarks.

Re: [pgadmin-hackers] CHANGELOG

2006-05-01 Thread Andreas Pflug
Dave Page wrote: -Original Message- From: Andreas Pflug[EMAIL PROTECTED] Sent: 01/05/06 15:36:36 To: Dave Pagedpage@vale-housing.co.uk Cc: pgadmin-hackers@postgresql.orgpgadmin-hackers@postgresql.org Subject: Re: CHANGELOG I don'T understand what you mean. What needs removing

Re: [pgadmin-hackers] Updated copy patch

2006-05-01 Thread Andreas Pflug
Though advised differently, the patch starts with removing the ListView stuff, so I won't look any further at this version. Use the macro, it won't hurt. Regards, Andreas ---(end of broadcast)--- TIP 5: don't forget to increase your free space

Re: [pgadmin-hackers] Lightspeed for frmQuery and other issues.

2006-04-30 Thread Andreas Pflug
Dave Page wrote: -Original Message- From: Andreas Pflug[EMAIL PROTECTED] Sent: 30/04/06 01:44:21 To: pgadmin-hackerspgadmin-hackers@postgresql.org, Dave Pagedpage@vale-housing.co.uk Subject: Lightspeed for frmQuery and other issues. as announced I realized the virtual listview

[pgadmin-hackers] Problem with autocomplete

2006-04-30 Thread Andreas Pflug
When triggering autocomplete on spaces (e.g. empty query window), a memory damage will be triggered. If ignored, the full keyword listbox will popup. Happens with VC6, not gtk. Regards, Andreas ---(end of broadcast)--- TIP 2: Don't 'kill -9' the

Re: [pgadmin-hackers] Lightspeed for frmQuery and other issues.

2006-04-30 Thread Andreas Pflug
Dave Page wrote: -Original Message- From: Andreas Pflug[EMAIL PROTECTED] Sent: 30/04/06 12:24:08 To: Dave Pagedpage@vale-housing.co.uk Cc: pgadmin-hackers@postgresql.orgpgadmin-hackers@postgresql.org Subject: Re: Lightspeed for frmQuery and other issues. Cool, nice work. I assume

Re: [pgadmin-hackers] Lightspeed for frmQuery and other issues.

2006-04-30 Thread Andreas Pflug
Dave Page wrote: -Original Message- From: Andreas Pflug[EMAIL PROTECTED] Sent: 30/04/06 14:48:08 To: Dave Pagedpage@vale-housing.co.uk Cc: pgadmin-hackers@postgresql.orgpgadmin-hackers@postgresql.org Subject: Re: Lightspeed for frmQuery and other issues. EditGrid is untouched

Re: [pgadmin-hackers] Lightspeed for frmQuery and other issues.

2006-04-30 Thread Andreas Pflug
Dave Page wrote: When asked for further info about *that* todo, you didn't give any helpful answers :-( Well, anybody not knowing how to code a virtual ListView shouldn't start on that... However, I am not complaining about that change - I am complaining that a copy/paste feature was

Re: [pgadmin-hackers] Lightspeed for frmQuery and other issues.

2006-04-30 Thread Andreas Pflug
Edward Di Geronimo Jr. wrote: Quoting Andreas Pflug [EMAIL PROTECTED]: Simply select some non-adjacent cells in arbitrary cols and rows. I stated that in the beginning, and asked if anyone had any suggestions on what to do in that case. If you completely arbitrarily hightlight cells

Re: [pgadmin-hackers] Lightspeed for frmQuery and other issues.

2006-04-30 Thread Andreas Pflug
Edward Di Geronimo Jr. wrote: Quoting Dave Page dpage@vale-housing.co.uk: Pasteing? I dunno. Anyway in MS Query Analyser you can paste entire rows, or sets of new rows into a table. I had been planning on looking at something similar, but with an additional option (offered at paste

Re: [pgadmin-hackers] Problem in graphical explain

2006-04-30 Thread Andreas Pflug
Miha Radej wrote: Hi! I have some tables and playing with a query and graphical explain got me to a strange result - a grey line across the entire window; see http://mcajvar.prkoritu.net/pgadmin/graphic_explain_db1.png . Ok Miha, apparently the problem is triggered by multiline filters. I

Re: [pgadmin-hackers] Lightspeed for frmQuery and other issues.

2006-04-30 Thread Andreas Pflug
Dave Page wrote: -Original Message- From: Andreas Pflug[EMAIL PROTECTED] Sent: 30/04/06 16:19:51 To: Dave Pagedpage@vale-housing.co.uk Cc: pgadmin-hackers@postgresql.orgpgadmin-hackers@postgresql.org Subject: Re: Lightspeed for frmQuery and other issues. It wasn't removed explicitely

Re: [pgadmin-hackers] Lightspeed for frmQuery and other issues.

2006-04-30 Thread Andreas Pflug
Edward Di Geronimo Jr. wrote: Quoting Andreas Pflug [EMAIL PROTECTED]: I still don't see a need for that extended handling, because the ctl always allowed row selections (and column selections can be achieved from SELECT , a basic SQL feature... ) Very often in my work, I would not know

Re: [pgadmin-hackers] Lightspeed for frmQuery and other issues.

2006-04-30 Thread Andreas Pflug
Dave Page wrote: Yes, but it used wxGrid methods to build the report, thus, like the copy functionality, would have needed fixing to work with a listview I already changed that to the new interface. (actually, frmReport has a listview-reporttable method that could be used). I don't quite

[pgadmin-hackers] programmers-readme.txt

2006-04-30 Thread Andreas Pflug
Hm, I could have sworn that I already added programmers-readme.txt months ago to svn. Anyway, please review it if it makes sense to you. Regards Andreas ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [pgadmin-hackers] Lightspeed for frmQuery and other issues.

2006-04-30 Thread Andreas Pflug
Dave Page wrote: -Original Message- From: Andreas Pflug[EMAIL PROTECTED] Sent: 30/04/06 18:44:01 To: Dave Pagedpage@vale-housing.co.uk Cc: pgadmin-hackers@postgresql.orgpgadmin-hackers@postgresql.org Subject: Re: Lightspeed for frmQuery and other issues. (actually, frmReport has

Re: [pgadmin-hackers] Commits 5097(1.4 branch) and 5096(trunk) break

2006-04-29 Thread Andreas Pflug
Florian G. Pflug wrote: Hi Starting from revisions 5097 (for 1.4) and 5096 (trunk) the OSX build failes for me. Seems like ::GetLastError() is undefined when using wxMac 2.6.2. Any ideas? Man, you really should upgrade your operating system to a compatible one... :-) GetLastError is a

[pgadmin-hackers] Lightspeed for frmQuery and other issues.

2006-04-29 Thread Andreas Pflug
Hi Dave, as announced I realized the virtual listview implementation in frmQuery; the code became amazingly slim. Since there's no more data retrieval, the retrieval time shrinks to precisely 0.00 microseconds which should be sufficiently fast to justify omitting this value :-) I left grid

Re: [pgadmin-hackers] Visual C++ 2005

2006-04-22 Thread Andreas Pflug
Magnus Hagander wrote: Sounds like distri bloating, for no benefit. Best would be if this manifest stuff could be omitted totally; we probably could link to the old msvcrt then. The bloat is only about 1.5Mb which isn't too bad, but having Or you can just link statically and then only

Re: [pgadmin-hackers] Visual C++ 2005

2006-04-21 Thread Andreas Pflug
Dave Page wrote: -Original Message- From: Hirodhi Saito [mailto:[EMAIL PROTECTED] Sent: 21 April 2006 16:36 To: Dave Page; pgadmin-hackers@postgresql.org Subject: Re: [pgadmin-hackers] Visual C++ 2005 Now that Visual C++ 2005 Express Edition is free from Microsoft, is there any

Re: [pgadmin-hackers] Visual C++ 2005

2006-04-21 Thread Andreas Pflug
Hirohi Saito wrote: I think VC++6 environment is required until it stops supporting W2K. Why? It has difficulty in offer by the MSVCRT problem. Probably, In the case of supply of a binary. There's a typo in your email name BTW: Hirodhi Saito Ahhh, even not only environment but my name

Re: [pgadmin-hackers] Visual C++ 2005

2006-04-21 Thread Andreas Pflug
Dave Page wrote: -Original Message- From: Andreas Pflug [mailto:[EMAIL PROTECTED] Sent: 21 April 2006 17:07 To: Dave Page Cc: Hiroshi Saito; pgadmin-hackers@postgresql.org Subject: Re: [pgadmin-hackers] Visual C++ 2005 Why? Apparently, VC2005 links mandatorily/unavoidable

Re: [pgadmin-hackers] Visual C++ 2005

2006-04-21 Thread Andreas Pflug
Dave Page wrote: I'm not so sure it's a problem - from Visual Studio's redist.txt: For your convenience, we have provided the following folders for use when redistributing VC++ runtime files. Subject to the license terms for the software, you may redistribute the folder (unmodified) in the

Re: [pgadmin-hackers] Visual C++ 2005

2006-04-21 Thread Andreas Pflug
Dave Page wrote: The bloat is only about 1.5Mb which isn't too bad, but having just watched literally thousands of warnings go past when compiling wxWidgets about all sorts of stuff like strdup being deprecated, I really can't be bothered to carry on. Perhaps when wx is cleaned up...

Re: [pgadmin-hackers] Clipboard update

2006-04-12 Thread Andreas Pflug
Dave Page wrote: -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 12 April 2006 04:48 To: pgadmin-hackers@postgresql.org Subject: [pgadmin-hackers] Clipboard update Here's a small update to the clipboard support. It adds

Re: [pgadmin-hackers] Problem in graphical explain

2006-04-12 Thread Andreas Pflug
Miha Radej wrote: Hi! I have some tables and playing with a query and graphical explain got me to a strange result - a grey line across the entire window; see http://mcajvar.prkoritu.net/pgadmin/graphic_explain_db1.png . There's something wrong here :-) I then made an exact duplicate copy

Re: [pgadmin-hackers] [pgadmin-support] Feature request - option

2006-04-05 Thread Andreas Pflug
Dave Page wrote: On 5/4/06 17:44, Miha Radej [EMAIL PROTECTED] wrote: Hi! I've been playing around a bit with this and I am sending attached a patch which Works For Me(tm). Since this was my first stab at anything such as this, I do hope it isn't too horrible :) The thought was to

[pgadmin-hackers] Query grid

2006-04-03 Thread Andreas Pflug
After several weeks I succeeded in reconnecting my win32 machine and have a look at pgadmin stuff again. I fired up the query tool and my first impression was can we have this a little less ugly please? when I saw those grey spaces. Is the tool expected to display up to 10G of rows? I

Re: [pgadmin-hackers] Query grid

2006-04-03 Thread Andreas Pflug
Dave Page wrote: -Original Message- From: Andreas Pflug [mailto:[EMAIL PROTECTED] Sent: 03 April 2006 14:22 To: [EMAIL PROTECTED]; Dave Page Cc: pgadmin-hackers Subject: Query grid After several weeks I succeeded in reconnecting my win32 machine and have a look at pgadmin stuff

Re: [pgadmin-hackers] Query grid

2006-04-03 Thread Andreas Pflug
Dave Page wrote: and we've already seen that the grid can be significantly faster than the list. This is plain wrong. I never said the current listview implementation is good; it isn't. But to rewrite it with wxVIRTUAL or however the style is called is for sure easier than doing it

Re: [pgadmin-hackers] Query grid

2006-04-03 Thread Andreas Pflug
Dave Page wrote: -Original Message- From: Andreas Pflug [mailto:[EMAIL PROTECTED] Sent: 03 April 2006 16:06 To: Dave Page Cc: pgadmin-hackers Subject: Re: [pgadmin-hackers] Query grid If the current implementation isn't rewritten, I'll commit a virtual rewrite of wxListView

Re: [pgadmin-hackers] Query grid

2006-04-03 Thread Andreas Pflug
Dave Page wrote: -Original Message- From: Andreas Pflug [mailto:[EMAIL PROTECTED] Sent: 03 April 2006 16:40 To: Dave Page Cc: pgadmin-hackers Subject: Re: [pgadmin-hackers] Query grid A correct implementation has *no* retrieval time, just some microseconds of setting up

Re: [pgadmin-hackers] Query grid

2006-04-03 Thread Andreas Pflug
Edward Di Geronimo Jr. wrote: Andreas Pflug wrote: A correct implementation has *no* retrieval time, just some microseconds of setting up the virtual control. Do you have any advice on how exactly to implement that behavior? It looked like the View Data grid did it by only retrieving

Re: [pgadmin-hackers] Tabbed Query Analyzer

2006-03-18 Thread Andreas Pflug
Nicholas Walker wrote: Just wondering if there has been a feature request for a tabbed query analyzer. Not inside of the main application, but whenever you request a new query analyzer window instead of opening a new window, just have a new tab, in the query analyzer window. Any thoughts.

Re: [pgadmin-hackers] Import from CSV - Questions

2006-03-14 Thread Andreas Pflug
Magnus Hagander wrote: Magnus, any chance of getting a look at what you currently have to help guide me in the appropriate direction? Umm. That would kind of assume it's written down in a comprehensible way. Which it isn't, of course :-) The general ideas so far have been, off the top

[pgadmin-hackers] some topics

2006-03-07 Thread Andreas Pflug
[EMAIL PROTECTED] wrote: Author: dpage Date: 2006-03-07 09:45:31 + (Tue, 07 Mar 2006) New Revision: 5047 Revision summary: http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/?rev=5047view=rev Log: Update for 1.4.2. Note that pgAdmin works with Mammoth PostgreSQL from Command Prompt. Did

Re: [pgadmin-hackers] some topics

2006-03-07 Thread Andreas Pflug
Dave Page wrote: -Original Message- From: Andreas Pflug [mailto:[EMAIL PROTECTED] Sent: 07 March 2006 10:34 To: Dave Page Cc: pgadmin-hackers@postgresql.org Subject: some topics [EMAIL PROTECTED] wrote: Author: dpage Date: 2006-03-07 09:45:31 + (Tue, 07 Mar 2006) New

Re: [pgadmin-hackers] some topics

2006-03-07 Thread Andreas Pflug
Dave Page wrote: -Original Message- From: Andreas Pflug [mailto:[EMAIL PROTECTED] Sent: 07 March 2006 10:40 To: Dave Page Cc: pgadmin-hackers@postgresql.org Subject: Re: some topics Noticed that. Will you put your project leader hat on and ask? Should be both of us to have

Re: [pgadmin-hackers] Query results in grid, new patch

2006-03-06 Thread Andreas Pflug
Florian G. Pflug wrote: .) Could the initial size of the columns be choosen so, that the captions are not cut off? Or, even better, pgadmin could remember the with of the columns between selects, at least if the captions stay the same... The old control's behaviour was like that. Regards,

Re: [pgadmin-hackers] Query results in grid, new patch

2006-03-06 Thread Andreas Pflug
Dave Page wrote: -Original Message- From: Andreas Pflug [mailto:[EMAIL PROTECTED] Sent: 06 March 2006 09:42 To: Florian G. Pflug Cc: Dave Page; Edward Di Geronimo Jr.; pgadmin-hackers@postgresql.org Subject: Re: [pgadmin-hackers] Query results in grid, new patch Florian G. Pflug

Re: [pgadmin-hackers] Query results in grid, new patch

2006-03-06 Thread Andreas Pflug
Dave Page wrote: -Original Message- From: Florian G. Pflug [mailto:[EMAIL PROTECTED] Sent: 06 March 2006 03:37 To: Florian G. Pflug Cc: Dave Page; Edward Di Geronimo Jr.; pgadmin-hackers@postgresql.org Subject: Re: [pgadmin-hackers] Query results in grid, new patch I've finally

Re: [pgadmin-hackers] Query results in grid, new patch

2006-03-06 Thread Andreas Pflug
Dave Page wrote: On 6/3/06 19:04, Andreas Pflug [EMAIL PROTECTED] wrote: Dave Page wrote: NOT a todo. I found the result something between annoying and useless when I implemented column sizing preserving, esp. in case of many columns. I still didn't have the time to have

Re: [pgadmin-hackers] 1.4.2?

2006-03-03 Thread Andreas Pflug
Dave Page wrote: Seems to me we might be about ready for 1.4.2. Any objections? If not, I'll look at wrapping it sometime next week. Go. Regards, Andreas ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an

Re: [pgadmin-hackers] missing translation strings?

2006-03-02 Thread Andreas Pflug
Miha Radej wrote: there is no sign of the string i searched for in any of the translation files, only in the code. should i manually extract the strings (generate the .pot catalogue) first? iirc this was being done automatically in the past, along with updating the .po files, wasn't it?

Re: [pgadmin-hackers] Query results in grid, new patch

2006-02-28 Thread Andreas Pflug
Dave Page wrote: Note to Andreas: unless you have any concrete technical reasons why this patch should not be applied, I'm fully intending to accept it once the current wrinkles are ironed out. Please shout now rather than later!! I won't find time to review it before the weekend.

Re: [pgadmin-hackers] localpipe

2006-02-27 Thread Andreas Pflug
Dave Page wrote: -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peter Eisentraut Sent: 24 February 2006 09:45 To: pgadmin-hackers@postgresql.org Subject: [pgadmin-hackers] localpipe pgAdmin talks about a localpipe, but the thing is in fact a

Re: [pgadmin-hackers] German translation

2006-02-27 Thread Andreas Pflug
Peter Eisentraut wrote: I went through the German translation and removed some excessive anglicisms and made some other corrections. Hm, I had a glance at what you changed, and I agree only partially. It's certainly horrible German style to omit the Bindestrich, I must admit that (thou in

Re: [pgadmin-hackers] German translation

2006-02-27 Thread Andreas Pflug
Peter Eisentraut wrote: Andreas Pflug wrote: I had a glance at what you changed, and I agree only partially. It's certainly horrible German style to omit the Bindestrich, I must admit that (thou in many cases, writing it in one word is the really correct style). But I'm still in favour for ß

Re: [pgadmin-hackers] Query tool results in grid

2006-02-23 Thread Andreas Pflug
Dave Page wrote: -Original Message- From: Edward Di Geronimo Jr. [mailto:[EMAIL PROTECTED] Sent: 21 February 2006 03:03 To: Andreas Pflug Cc: Dave Page; pgadmin-hackers@postgresql.org Subject: Re: [pgadmin-hackers] Query tool results in grid This problem is partly alleviated

Re: [pgadmin-hackers] pgAdmin server properties dialog

2006-02-23 Thread Andreas Pflug
Peter Eisentraut wrote: I have a few comments on the server properties dialog on issues that have bothered me for a long time. First, the title of the window is something like Server localhost, which means nothing. Perhaps this should be Connection Properties or Server Properties. When I

Re: [pgadmin-hackers] select inside transactions

2006-02-23 Thread Andreas Pflug
Magnus Hagander wrote: I had to revert the patch on pgSetBase.cpp (Rev4986) because to handle the very special case of selects inside transactions when executed in a single step (I'd recommend to execute them step by step) the standard case of a query returning no data (e.g. drop table

Re: [pgadmin-hackers] detecting serials in 8.1

2006-02-20 Thread Andreas Pflug
Kris Jurka wrote: Andreas Pflug wrote: Kris Jurka wrote: Actually it turns out that whether the schema gets in there or not depends on the search path when the table is created. That's what pgSchema::GetPrefix does too. That's fine as long as you assume that the search path never

Re: [pgadmin-hackers] Query tool results in grid

2006-02-20 Thread Andreas Pflug
[EMAIL PROTECTED] wrote: I've attached a preliminary patch to display the results of the Query Tool using a grid control instead of a list. Sorry to frustrate you, but using the grid is provenly even more ineffective (on _all_ platforms) than the current one. wxGrid is known to degrade

Re: [pgadmin-hackers] detecting serials in 8.1

2006-02-20 Thread Andreas Pflug
Kris Jurka wrote: Andreas Pflug wrote: It's _always_ fine, because GetSchema obeys the search path and the reengineered SQL is meant to be used in a search path situation as it was at the time of reengineering. There are plenty of other situations where the reduced form (omitting search

[pgadmin-hackers] select inside transactions

2006-02-19 Thread Andreas Pflug
I had to revert the patch on pgSetBase.cpp (Rev4986) because to handle the very special case of selects inside transactions when executed in a single step (I'd recommend to execute them step by step) the standard case of a query returning no data (e.g. drop table foo) didn't return messages

Re: [pgadmin-hackers] SVN Commit by dpage: r5000 - in trunk/pgadmin3:

2006-02-19 Thread Andreas Pflug
Kris Jurka wrote: [EMAIL PROTECTED] wrote: Author: dpage Date: 2006-02-17 10:49:24 + (Fri, 17 Feb 2006) New Revision: 5000 Revision summary: http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/?rev=5000view=rev Log: Properly escape single quotes in connection strings. This commit

Re: [pgadmin-hackers] select inside transactions

2006-02-19 Thread Andreas Pflug
Magnus Hagander wrote: I had to revert the patch on pgSetBase.cpp (Rev4986) because to handle the very special case of selects inside transactions when executed in a single step (I'd recommend to execute them step by step) the standard case of a query returning no data (e.g. drop table foo)

Re: [pgadmin-hackers] SVN Commit by dpage: r5003 - in trunk/pgadmin3:

2006-02-19 Thread Andreas Pflug
Kris Jurka wrote: [EMAIL PROTECTED] wrote: Author: dpage Date: 2006-02-17 11:05:34 + (Fri, 17 Feb 2006) New Revision: 5003 Revision summary: http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/?rev=5003view=rev Log: Mask the password when logging the connection string. This crashes for

Re: [pgadmin-hackers] detecting serials in 8.1

2006-02-19 Thread Andreas Pflug
Kris Jurka wrote: 8.1 has changed the default text for serials from something like nextval('public.tab_col_seq'::text) to nextval('tab_col_seq'::regclass) Applied with editing (didn't check for schema). + // Technically this serial check can still fail for sequences that + // get

Re: [pgadmin-hackers] detecting serials in 8.1

2006-02-19 Thread Andreas Pflug
Kris Jurka wrote: Andreas Pflug wrote: Kris Jurka wrote: 8.1 has changed the default text for serials from something like nextval('public.tab_col_seq'::text) to nextval('tab_col_seq'::regclass) Applied with editing (didn't check for schema). Actually it turns out that whether

Re: [pgadmin-hackers] Change password issue

2006-02-17 Thread Andreas Pflug
Dave Page wrote: On the TODO list. It is? Can't see it for looking :-( I meant _Let's put it_ on the TODO list. Apparenly abbrevations and omissions might lead to decreased understandability :-) Regards, Andreas ---(end of broadcast)---

[pgadmin-hackers] Query favourite comment

2006-02-13 Thread Andreas Pflug
After quite a while, I finally found the time to package a win32 snapshot. Some comments: 1) apparently, we need two iconv dlls now: iconv.dll for xml2 and libiconv-2.dll for libpq. Hm... 2) When adding a favourite, the whole buffer is taken, not just the marked area. This differs from the

Re: [pgadmin-hackers] Query favourite comment

2006-02-13 Thread Andreas Pflug
Magnus Hagander wrote: Can we link iconv statically? (That's what I did for my tests, that's probably why I didn't notice it) I'm a friend of static linkage, esp. if only a small fraction of a dll's functions are used. As for the replace vs. insert issue, when I tested it it asked me if I

Re: [pgadmin-hackers] Query favourite comment

2006-02-13 Thread Andreas Pflug
Dave Page wrote: -Original Message- From: Magnus Hagander [mailto:[EMAIL PROTECTED] Sent: 13 February 2006 14:01 To: Dave Page; Andreas Pflug Cc: pgadmin-hackers Subject: RE: [pgadmin-hackers] Query favourite comment After quite a while, I finally found the time to package

Re: [pgadmin-hackers] Patch: Query favourites

2006-02-13 Thread Andreas Pflug
Dave Page wrote: Patch applied with the following changes: - Moved all deps to $PGASRC/../pgadmin3-deps/ on Windows. - Replaced the wxTreeCtrl with a ctlTree (which draws lines properly on GTK), and added the appropriate XRC resource handlers. There is a slightly odd effect with the text box

Re: [pgadmin-hackers] Query favourite comment

2006-02-13 Thread Andreas Pflug
Dave Page wrote: -Original Message- From: Andreas Pflug [mailto:[EMAIL PROTECTED] Sent: 13 February 2006 14:18 To: Dave Page Cc: Magnus Hagander; pgadmin-hackers Subject: Re: [pgadmin-hackers] Query favourite comment So what? AFAICS we're complying with section 6 (a/d) of LPGL

Re: [pgadmin-hackers] Patch: Query favourites

2006-02-07 Thread Andreas Pflug
Magnus Hagander wrote: On a related note, this introduces dependencies on libxml2 and iconv. These are both available from www.xmlsoft.org, precompiled for Windows, and are both on most unixes already, however, on Windows there is no standard place for them to live. There are two

Re: [pgadmin-hackers] Improved copying from Edit Data Grid - rough

2006-02-06 Thread Andreas Pflug
Dave Page wrote: If you'd like to look at adding similar functionality to the query tool, that'd be great :-) Please note that the query tool output needs major redesign to use a virtual control; the current (wx) implementation is dead slow on some platforms. Regards, Andreas

Re: [pgadmin-hackers] GrantWizard Property Crack?

2006-01-31 Thread Andreas Pflug
Hiroshi Saito wrote: Hi Andreas. I am looking at the strange thing.? see, http://cre-ent.skcapi.co.jp/~saito/pgadmin3/pgAdmin3_GrantWizard_Crack.PNG Do you understand this somehow? Don't have a clue where this comes from: the notebook pages has only the checklistbox and two buttons. Could

Re: [pgadmin-hackers] Patch: Query favourites

2006-01-31 Thread Andreas Pflug
Dave Page wrote: -Original Message- From: Magnus Hagander [mailto:[EMAIL PROTECTED] Sent: 30 January 2006 20:22 To: Dave Page; Andreas Pflug Cc: pgadmin-hackers@postgresql.org Subject: RE: [pgadmin-hackers] Patch: Query favourites As for the libxml2/msxml - I think going

Re: [pgadmin-hackers] Patch: Query favourites

2006-01-31 Thread Andreas Pflug
Dave Page wrote: -Original Message- From: Andreas Pflug [mailto:[EMAIL PROTECTED] Sent: 31 January 2006 12:19 To: Dave Page Cc: Magnus Hagander; pgadmin-hackers@postgresql.org Subject: Re: [pgadmin-hackers] Patch: Query favourites I didn't think of one repository per server

Re: [pgadmin-hackers] Patch: Query favourites

2006-01-31 Thread Andreas Pflug
Dave Page wrote: -Original Message- From: Andreas Pflug [mailto:[EMAIL PROTECTED] Sent: 31 January 2006 16:27 To: Dave Page Cc: Magnus Hagander; pgadmin-hackers@postgresql.org Subject: Re: [pgadmin-hackers] Patch: Query favourites Hm, don't see the connection to pgAgent. What I

Re: [pgadmin-hackers] Query tool: Autocompletion

2006-01-30 Thread Andreas Pflug
Dave Page wrote: Thanks, patch applied with minor tweaking re: trailing spaces as discussed on IM, and documentation. I eyeballed the multibyte handling, it looks ok to me. But I found some nasty misbehaviours: select * from pg_cTAB - On Windows, a popup will appear. If you activate a

Re: [pgadmin-hackers] Query tool: Autocompletion

2006-01-30 Thread Andreas Pflug
Dave Page wrote: Thanks, patch applied with minor tweaking re: trailing spaces as discussed on IM, and documentation. More problems on Linux: - select * from pg_cCtrl-Spc) _does_ popup the window. However, the popup will show the same problem as on Windows, remaining on top of all windows.

Re: [pgadmin-hackers] Patch: Query favourites

2006-01-30 Thread Andreas Pflug
Dave Page wrote: -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Magnus Hagander Sent: 29 January 2006 20:56 To: Andreas Pflug Cc: pgadmin-hackers@postgresql.org Subject: Re: [pgadmin-hackers] Patch: Query favourites On this we clearly disagree

Re: [pgadmin-hackers] Patch: Query favourites

2006-01-29 Thread Andreas Pflug
Magnus Hagander wrote: This patch adds a favourites menu to the query tool, where one can store often-used queries. It brings along build dependencies on wxxml2 (http://wxcode.sourceforge.net/components/wxxml2/) and libxml2 (which comes from the first). The tradeoff between additional benefit

Re: [pgadmin-hackers] Patch: Query favourites

2006-01-29 Thread Andreas Pflug
Magnus Hagander wrote: Anyway, it could be rewritten to either not use XML at all, or to not use wxxml (say by linking directly to libxml, which is likely to be on the system already considering how many packages use it). It just makes it easier when you don't have to maintain the code

Re: [pgadmin-hackers] Patch: Query favourites

2006-01-29 Thread Andreas Pflug
Magnus Hagander wrote: Anyway, it could be rewritten to either not use XML at all, or to not use wxxml (say by linking directly to libxml, which is likely to be on the system already considering how many packages use it). It just makes it easier when

Re: [pgadmin-hackers] Query tool: Autocompletion

2006-01-26 Thread Andreas Pflug
Dave Page wrote: -Original Message- From: Andreas Pflug [mailto:[EMAIL PROTECTED] Sent: 26 January 2006 00:06 To: Magnus Hagander Cc: Dave Page; pgadmin-hackers@postgresql.org Subject: Re: [pgadmin-hackers] Query tool: Autocompletion I've spent several hours now to get the beast

Re: [pgadmin-hackers] SVN Commit by dpage: r4965 - trunk/pgadmin3

2006-01-25 Thread Andreas Pflug
[EMAIL PROTECTED] wrote: Author: dpage Date: 2006-01-25 10:31:01 + (Wed, 25 Jan 2006) New Revision: 4965 Revision summary: http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/?rev=4965view=rev Log: Testing post-commit email script... Adding frmPgpassConfig.* would be a great idea too...

Re: [pgadmin-hackers] SVN Commit by dpage: r4965 - trunk/pgadmin3

2006-01-25 Thread Andreas Pflug
Dave Page wrote: Adding frmPgpassConfig.* would be a great idea too... Yeah, yeah, picky, picky ! As usual :-) To continue: The pgpass dialog captions could need some review... Regards, Andreas ---(end of broadcast)--- TIP 9: In versions

Re: [pgadmin-hackers] pgAdmin website translations

2006-01-25 Thread Andreas Pflug
Dave Page wrote: When you have finished, please do not forget to set your name and email address in the translation header, then forward me the .po and .mo files to be added to the site. Translation template: http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/*checkout*/trunk/www/locale/p

Re: [pgadmin-hackers] Query tool: Autocompletion

2006-01-25 Thread Andreas Pflug
I've spent several hours now to get the beast compiled, still no go. It's a nightmare I don't like to spend more time on. Dave, if you succeed hacking something workable that doesn't try to call more core pgsql includes from somewhere (!), commit it. Note: pgsql copied stuff should go to

Re: [pgadmin-hackers] bugfix: Encoding of config files

2006-01-24 Thread Andreas Pflug
Dave Page wrote: -Original Message- From: Andreas Pflug [mailto:[EMAIL PROTECTED] Sent: 23 January 2006 23:31 To: Dave Page Cc: Magnus Hagander; pgadmin-hackers@postgresql.org Subject: Re: [pgadmin-hackers] bugfix: Encoding of config files NB, when reading AND writing

Re: [pgadmin-hackers] bugfix: Encoding of config files

2006-01-23 Thread Andreas Pflug
Dave Page wrote: Thanks, patch applied to 1.4.x and 1.6. Hm, this certainly should be consistent, but I'd guess most files will use a 1-byte system charset, not UTF8, thus wxConvLibc not wxConvUTF8 is the right one. Regards, Andreas ---(end of

Re: [pgadmin-hackers] Patch: Config editors

2006-01-23 Thread Andreas Pflug
Magnus Hagander wrote: Attached patch implements an editor for pgpass.conf/.pgpass modeled on the HBA editor. In doing so it also: Do we need this? .pgpass is maintained automatically from pgAdmin. No it's not :-) Not if you want to use wildcards, for example. Or

Re: [pgadmin-hackers] bugfix: Encoding of config files

2006-01-23 Thread Andreas Pflug
Magnus Hagander wrote: Thanks, patch applied to 1.4.x and 1.6. Hm, this certainly should be consistent, but I'd guess most files will use a 1-byte system charset, not UTF8, thus wxConvLibc not wxConvUTF8 is the right one. I for one certainly bow to that one. As said before,

  1   2   3   4   5   6   7   8   9   10   >