[pgadmin-hackers] SVN Commit by dpage: r6877 - trunk/www/download

2007-12-10 Thread svn
Author: dpage Date: 2007-12-10 09:18:59 + (Mon, 10 Dec 2007) New Revision: 6877 Revision summary: http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/?rev=6877&view=rev Log: Add RPM download link Modified: trunk/www/download/rpm.php ---(end of broadcast)

[pgadmin-hackers] SVN Commit by dpage: r6878 - in trunk/pgadmin3: . pgadmin/debugger

2007-12-10 Thread svn
Author: dpage Date: 2007-12-10 11:17:15 + (Mon, 10 Dec 2007) New Revision: 6878 Revision summary: http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/?rev=6878&view=rev Log: Fix the debugger's connection class to ensure database names requiring quotes will work and that is can be used with SSL and

[pgadmin-hackers] SVN Commit by dpage: r6879 - in branches/REL-1_8_0_PATCHES/pgadmin3: . pgadmin/debugger

2007-12-10 Thread svn
Author: dpage Date: 2007-12-10 11:18:33 + (Mon, 10 Dec 2007) New Revision: 6879 Revision summary: http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/?rev=6879&view=rev Log: Fix the debugger's connection class to ensure database names requiring quotes will work and that is can be used with SSL and

Re: [pgadmin-hackers] Submitting cursored query support, docs, etc

2007-12-10 Thread Kalle Hallivuori
Hi again Dave and others, 2007/11/29, Dave Page <[EMAIL PROTECTED]>: > I'd be very happy to look at your code. Obviously I cannot guarantee > that it would all be incorporated into the base product, but certainly > all of the items above sound very interesting (I've personally wanted to > add a cu

[pgadmin-hackers] 2 errors when accessing schema->public

2007-12-10 Thread Horacio de Oro
Hi! I've installed PGadmin III 1.6.3 (downloaded from the pgadmin site) for working with PostgreSql 8.3beta4. When going to "Schemas -> public" for the first time, or when doing a "refresh" on "Schemas -> public" I get 2 errors: ERROR 1: An error has occurred: ERROR: column op.oprlsortop does not

Re: [pgadmin-hackers] 2 errors when accessing schema->public

2007-12-10 Thread Dave Page
Horacio de Oro wrote: > Hi! > I've installed PGadmin III 1.6.3 (downloaded from the pgadmin site) for > working with PostgreSql 8.3beta4. When going to "Schemas -> public" for > the first time, or when doing a "refresh" on "Schemas -> public" I get 2 > errors: pgAdmin 1.6.x doesn't support Postgre

Re: [pgadmin-hackers] Submitting cursored query support, docs, etc

2007-12-10 Thread Dave Page
Kalle Hallivuori wrote: > Hi again Dave and others, > > 2007/11/29, Dave Page <[EMAIL PROTECTED]>: >> I'd be very happy to look at your code. Obviously I cannot guarantee >> that it would all be incorporated into the base product, but certainly >> all of the items above sound very interesting (I'v

[pgadmin-hackers] SVN Commit by dpage: r6880 - in trunk/pgadmin3: . pgadmin/dlg pgadmin/include/schema pgadmin/schema pgadmin/ui

2007-12-10 Thread svn
Author: dpage Date: 2007-12-10 14:00:53 + (Mon, 10 Dec 2007) New Revision: 6880 Revision summary: http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/?rev=6880&view=rev Log: Add support for typmod in/out functions on custom types [Guillaume Lelarge] Modified: trunk/pgadmin3/CHANGELOG trunk/p

Re: [pgadmin-hackers] Patch to add typmod's functions to a type's creation statement

2007-12-10 Thread Dave Page
Guillaume Lelarge wrote: > Guillaume Lelarge a écrit : >> If I correctly read the CREATE TYPE manpage, I need to check that the >> type_modifier_input_function function has one argument of type cstring[] >> and returns an integer. And I need to check that the >> type_modifier_output_function functi

[pgadmin-hackers] SVN Commit by dpage: r6881 - branches/REL-1_8_0_PATCHES/pgadmin3

2007-12-10 Thread svn
Author: dpage Date: 2007-12-10 14:02:32 + (Mon, 10 Dec 2007) New Revision: 6881 Revision summary: http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/?rev=6881&view=rev Log: Correct a date Modified: branches/REL-1_8_0_PATCHES/pgadmin3/CHANGELOG ---(end of broadcast)

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

2007-12-10 Thread svn
Author: dpage Date: 2007-12-10 14:13:26 + (Mon, 10 Dec 2007) New Revision: 6882 Revision summary: http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/?rev=6882&view=rev Log: Correct a couple of version numbers Modified: trunk/pgadmin3/CHANGELOG ---(end of broadcast)

[pgadmin-hackers] SVN Commit by dpage: r6883 - in branches/REL-1_8_0_PATCHES/pgadmin3: . pgadmin/schema pgadmin/utils

2007-12-10 Thread svn
Author: dpage Date: 2007-12-10 14:35:50 + (Mon, 10 Dec 2007) New Revision: 6883 Revision summary: http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/?rev=6883&view=rev Log: Handle the corner case when a user includes quotes in an object name (backport of 2007-10-26 fix applied to trunk) Modified

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

2007-12-10 Thread svn
Author: dpage Date: 2007-12-10 14:36:44 + (Mon, 10 Dec 2007) New Revision: 6884 Revision summary: http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/?rev=6884&view=rev Log: Update changelog following backport of 2007-10-26 fix applied to trunk Modified: trunk/pgadmin3/CHANGELOG --

[pgadmin-hackers] Creating types

2007-12-10 Thread Dave Page
A short while ago I noticed that there are a couple of issues when creating new datatypes which essentially mean the disalogue is useless for creating 'external' types (as opposed to enums or composite types. The basic problem is that the input, output, send and receive functions are have the type

[pgadmin-hackers] Number of connections

2007-12-10 Thread Roberts, Jon
I've noticed that when using pgAdmin, each user will have multiple connections to the database. We actually observe three connections for each user which seem to be: 1. pgAdmin UI 2. Maintenance database 3. Query Window Then for each Query Window, there is another connection created. So if a

Re: [pgadmin-hackers] Number of connections

2007-12-10 Thread Heikki Linnakangas
Roberts, Jon wrote: I've noticed that when using pgAdmin, each user will have multiple connections to the database. We actually observe three connections for each user which seem to be: 1. pgAdmin UI 2. Maintenance database 3. Query Window Then for each Query Window, there is another connect

Re: [pgadmin-hackers] Number of connections

2007-12-10 Thread Roberts, Jon
> -Original Message- > From: Heikki Linnakangas [mailto:[EMAIL PROTECTED] On Behalf Of Heikki > Linnakangas > Sent: Monday, December 10, 2007 9:12 AM > To: Roberts, Jon > Cc: pgadmin-hackers > Subject: Re: [pgadmin-hackers] Number of connections > > Roberts, Jon wrote: > > I've noticed t

Re: [pgadmin-hackers] Number of connections

2007-12-10 Thread Dave Page
Roberts, Jon wrote: > I would think far less code would be needed if the tool could be configured > to only use one connection. How'd you figure that? You'd need to write the connection pooler, start tracking connection states in far more detail than we do now, and potentially have to start new

Re: [pgadmin-hackers] Number of connections

2007-12-10 Thread Roberts, Jon
> -Original Message- > From: Dave Page [mailto:[EMAIL PROTECTED] > Sent: Monday, December 10, 2007 9:42 AM > To: Roberts, Jon > Cc: pgadmin-hackers > Subject: Re: [pgadmin-hackers] Number of connections > > Roberts, Jon wrote: > > I would think far less code would be needed if the tool cou

Re: [pgadmin-hackers] Number of connections

2007-12-10 Thread Dave Page
Roberts, Jon wrote: > I mean this: > Solution 1: Manage a complicated connection pool like you described above. > Solution 2: Only allow one connection to the database. A new query window > will not create a new connection. The tool will not allow new queries to > execute while another query is e

Re: [pgadmin-hackers] Number of connections

2007-12-10 Thread Roberts, Jon
> -Original Message- > From: Dave Page [mailto:[EMAIL PROTECTED] > Sent: Monday, December 10, 2007 10:11 AM > To: Roberts, Jon > Cc: pgadmin-hackers > Subject: Re: [pgadmin-hackers] Number of connections > > Roberts, Jon wrote: > > I mean this: > > Solution 1: Manage a complicated connec

[pgadmin-hackers] SVN Commit by hiroshi: r6885 - in trunk/pgadmin3: . pgadmin/ctl

2007-12-10 Thread svn
Author: hiroshi Date: 2007-12-10 17:25:50 + (Mon, 10 Dec 2007) New Revision: 6885 Revision summary: http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/?rev=6885&view=rev Log: Add the keyword 'WHILE' of debugger. Modified: trunk/pgadmin3/CHANGELOG trunk/pgadmin3/pgadmin/ctl/ctlSQLBox.cpp -

Re: [pgadmin-hackers] Creating types

2007-12-10 Thread Guillaume Lelarge
Dave Page a écrit : > [...] > I'm currently thinking the way forward is to do the following: > > - Allow the user to create shell types. This would be another option > alongside Composite, Enumeration and External. > > - Populate the combo boxes for the aforementioned functions when the > user ch