Re: [pgadmin-support] Not able to add or remove argument in Parameters tab, Function Properties

2007-11-12 Thread Dave Page
Guillaume Lelarge wrote: > Dave Page a écrit : >> Guillaume Lelarge wrote: >>> Dave Page a écrit : You cannot change foo(int, int) to foo(int, int, int) because it would become a whole new function. Thus you can only add/remove parameters at initial design time. >>> OK, we're no

Re: [pgadmin-support] Not able to add or remove argument in Parameters tab, Function Properties

2007-11-12 Thread Guillaume Lelarge
Dave Page a écrit : > Guillaume Lelarge wrote: >> Dave Page a écrit : >>> You cannot change foo(int, int) to foo(int, int, int) because it would >>> become a whole new function. Thus you can only add/remove parameters at >>> initial design time. >>> >> OK, we're not talking about the same thing. I

Re: [pgadmin-support] Not able to add or remove argument in Parameters tab, Function Properties

2007-11-12 Thread Dave Page
Guillaume Lelarge wrote: > Dave Page a écrit : >> You cannot change foo(int, int) to foo(int, int, int) because it would >> become a whole new function. Thus you can only add/remove parameters at >> initial design time. >> > > OK, we're not talking about the same thing. I was referring to session

Re: [pgadmin-support] Not able to add or remove argument in Parameters tab, Function Properties

2007-11-12 Thread Guillaume Lelarge
Dave Page a écrit : > Guillaume Lelarge wrote: >> Dave Page a écrit : >>> Guillaume Lelarge wrote: zoran a écrit : > Hi, > > Do buttons Add and Remove in Parameters tab have purpose? > They have when you're connected to a PostgreSQL 8.3 server. Dave, do you think

Re: [pgadmin-support] Not able to add or remove argument in Parameters tab, Function Properties

2007-11-12 Thread Dave Page
Guillaume Lelarge wrote: > Dave Page a écrit : >> Guillaume Lelarge wrote: >>> zoran a écrit : Hi, Do buttons Add and Remove in Parameters tab have purpose? >>> They have when you're connected to a PostgreSQL 8.3 server. >>> >>> Dave, do you think we should hide the parameters'

Re: [pgadmin-support] Not able to add or remove argument in Parameters tab, Function Properties

2007-11-12 Thread Guillaume Lelarge
Dave Page a écrit : > Guillaume Lelarge wrote: >> zoran a écrit : >>> Hi, >>> >>> Do buttons Add and Remove in Parameters tab have purpose? >>> >> They have when you're connected to a PostgreSQL 8.3 server. >> >> Dave, do you think we should hide the parameters' tab when used with >> pre-8.3 server

[pgadmin-support] Problem with autocomplete in 1.8 (win xp)

2007-11-12 Thread Hernan J. Gonzalez
I have the same issue described previously http://www.pgadmin.org/archives/pgadmin-support/2007-09/msg00147.php In the Query editor, items in the autocomplete drop-down lists cannot be selected by the Enter key, it just enters (systematically) a newline in the editor window. You must use the mo

Re: [pgadmin-support] Not able to add or remove argument in Parameters tab, Function Properties

2007-11-12 Thread Dave Page
Guillaume Lelarge wrote: > zoran a écrit : >> Hi, >> >> Do buttons Add and Remove in Parameters tab have purpose? >> > > They have when you're connected to a PostgreSQL 8.3 server. > > Dave, do you think we should hide the parameters' tab when used with > pre-8.3 servers ? I can write a patch for

Re: [pgadmin-support] generating UPDATE SET ... WHERE PK = ...

2007-11-12 Thread Guillaume Lelarge
Laurent ROCHE a écrit : > I would like to generate with a request a SQL order like > UPDATE tab1 > SET col_a = ?, col_b = ? ... > WHERE pk = ? > > for each table of a given schema (in fact what I want is slightly more > complicated but if I can write the above, I will be able to get the rest). >

Re: [pgadmin-support] Not able to add or remove argument in Parameters tab, Function Properties

2007-11-12 Thread Guillaume Lelarge
zoran a écrit : > Hi, > > Do buttons Add and Remove in Parameters tab have purpose? > They have when you're connected to a PostgreSQL 8.3 server. Dave, do you think we should hide the parameters' tab when used with pre-8.3 servers ? I can write a patch for this. Regards. -- Guillaume. http

Re: [pgadmin-support] Installing pgAdmin3 version 1.8.0 on Ubuntu Gutsy distribution

2007-11-12 Thread Guillaume Lelarge
Gabriel Giroux a écrit : > I'm using GNU/Linux Ubuntu Gutsy Gibbon distribution on a Laptop where > PostgreSQL 8.2.5 has been isntalled. > > I'm a newbie on Gnu/Linux OS and I would like to know if anybody in > there has tested the new pgAdmin3 release on GNU/Linux Ubuntu Gutsy > Gibbon distributi

Re: [pgadmin-support] no timestamp type available in pgadmin3

2007-11-12 Thread Guillaume Lelarge
Anton Andreev a écrit : > It could be my fault, but I continue not to see the timestamp type when > I am creating a new column in PgAdmin3? > You don't see "timestamp with timezone" and "timestamp without timezone" types ? BTW, "timestamp without timezone" and "timestamp" are the same. What do yo

Re: [pgadmin-support] Error 1069: The service did not start due to a logon failure.

2007-11-12 Thread Dave Page
As I said before, please keep your replies on the mailing list. I don't provide private support (unless you wish to purchase a support contract) . Tommy Flewwelling wrote: > David, I assume you mean Dave? > > I don’t mean to pester you but possibly you could tell me how pgAgent is > authenticat