Re: Not able to add or remove argument in Parameters tab, Function Properties

Lists: pgadmin-support
From: zoran <zoran(dot)cincovic(at)a-asoft(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: Not able to add or remove argument in Parameters tab, Function Properties
Date: 2007-10-31 15:04:49
Message-ID: [email protected]
Views: Whole Thread | Raw Message | Download mbox | Resend email
Lists: pgadmin-support

Hi,

Do buttons Add and Remove in Parameters tab have purpose?

Regards,
Zoran


From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: zoran <zoran(dot)cincovic(at)a-asoft(dot)com>
Cc: pgadmin-support(at)postgresql(dot)org, Dave Page <dpage(at)postgresql(dot)org>
Subject: Re: Not able to add or remove argument in Parameters tab, Function Properties
Date: 2007-11-12 14:47:05
Message-ID: [email protected]
Views: Whole Thread | Raw Message | Download mbox | Resend email
Lists: pgadmin-support

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://www.postgresqlfr.org
http://dalibo.com


From: Dave Page <dpage(at)postgresql(dot)org>
To: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
Cc: zoran <zoran(dot)cincovic(at)a-asoft(dot)com>, pgadmin-support(at)postgresql(dot)org
Subject: Re: Not able to add or remove argument in Parameters tab, Function Properties
Date: 2007-11-12 14:58:23
Message-ID: [email protected]
Views: Whole Thread | Raw Message | Download mbox | Resend email
Lists: pgadmin-support

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 this.

No - parameters are used in all versions of PostgreSQL. You can only
add/remove them when creating the function though, not when editing it
(because that would change the signature, thus making it a new function).

/D


From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Dave Page <dpage(at)postgresql(dot)org>
Cc: zoran <zoran(dot)cincovic(at)a-asoft(dot)com>, pgadmin-support(at)postgresql(dot)org
Subject: Re: Not able to add or remove argument in Parameters tab, Function Properties
Date: 2007-11-12 15:05:55
Message-ID: [email protected]
Views: Whole Thread | Raw Message | Download mbox | Resend email
Lists: pgadmin-support

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 servers ? I can write a patch for this.
>
> No - parameters are used in all versions of PostgreSQL. You can only
> add/remove them when creating the function though, not when editing it
> (because that would change the signature, thus making it a new function).
>

I thought it was an 8.3 new feature ?

--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com


From: Dave Page <dpage(at)postgresql(dot)org>
To: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
Cc: zoran <zoran(dot)cincovic(at)a-asoft(dot)com>, pgadmin-support(at)postgresql(dot)org
Subject: Re: Not able to add or remove argument in Parameters tab, Function Properties
Date: 2007-11-12 15:29:43
Message-ID: [email protected]
Views: Whole Thread | Raw Message | Download mbox | Resend email
Lists: pgadmin-support

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' tab when used with
>>> pre-8.3 servers ? I can write a patch for this.
>> No - parameters are used in all versions of PostgreSQL. You can only
>> add/remove them when creating the function though, not when editing it
>> (because that would change the signature, thus making it a new function).
>>
>
> I thought it was an 8.3 new feature ?

eh?

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.

/D


From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Dave Page <dpage(at)postgresql(dot)org>
Cc: zoran <zoran(dot)cincovic(at)a-asoft(dot)com>, pgadmin-support(at)postgresql(dot)org
Subject: Re: Not able to add or remove argument in Parameters tab, Function Properties
Date: 2007-11-12 15:46:49
Message-ID: [email protected]
Views: Whole Thread | Raw Message | Download mbox | Resend email
Lists: pgadmin-support

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 we should hide the parameters' tab when used with
>>>> pre-8.3 servers ? I can write a patch for this.
>>> No - parameters are used in all versions of PostgreSQL. You can only
>>> add/remove them when creating the function though, not when editing it
>>> (because that would change the signature, thus making it a new function).
>>>
>> I thought it was an 8.3 new feature ?
>
> eh?
>
> 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
parameters that can be added to functions in 8.3 :)

Now that I re-read the mail subject, my answer was completely wrong.

Sorry about his.

--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com


From: Dave Page <dpage(at)postgresql(dot)org>
To: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
Cc: zoran <zoran(dot)cincovic(at)a-asoft(dot)com>, pgadmin-support(at)postgresql(dot)org
Subject: Re: Not able to add or remove argument in Parameters tab, Function Properties
Date: 2007-11-12 16:00:51
Message-ID: [email protected]
Views: Whole Thread | Raw Message | Download mbox | Resend email
Lists: pgadmin-support

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
> parameters that can be added to functions in 8.3 :)

Ah, those would be what we refer to as variables :-)

> Now that I re-read the mail subject, my answer was completely wrong.
>
> Sorry about his.

No problem.

/D


From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Dave Page <dpage(at)postgresql(dot)org>
Cc: zoran <zoran(dot)cincovic(at)a-asoft(dot)com>, pgadmin-support(at)postgresql(dot)org
Subject: Re: Not able to add or remove argument in Parameters tab, Function Properties
Date: 2007-11-12 16:46:06
Message-ID: [email protected]
Views: Whole Thread | Raw Message | Download mbox | Resend email
Lists: pgadmin-support

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 was referring to session
>> parameters that can be added to functions in 8.3 :)
>
> Ah, those would be what we refer to as variables :-)
>

You're right. My question is still open : should we hide or disable tabs
when informations are not available for the selected server ? for
exemple the variables tab for a pre-8.3 server...

--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com


From: Dave Page <dpage(at)postgresql(dot)org>
To: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
Cc: zoran <zoran(dot)cincovic(at)a-asoft(dot)com>, pgadmin-support(at)postgresql(dot)org
Subject: Re: Not able to add or remove argument in Parameters tab, Function Properties
Date: 2007-11-12 16:54:02
Message-ID: [email protected]
Views: Whole Thread | Raw Message | Download mbox | Resend email
Lists: pgadmin-support

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 not talking about the same thing. I was referring to session
>>> parameters that can be added to functions in 8.3 :)
>> Ah, those would be what we refer to as variables :-)
>>
>
> You're right. My question is still open : should we hide or disable tabs
> when informations are not available for the selected server ? for
> exemple the variables tab for a pre-8.3 server...

No, we don't do that elsewhere I don't think so we shouldn't here either.

/D