SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-17-2008, 08:13 PM
| ||||
| ||||
 Not able to add or remove argument in Parameters tab, Function Properties Hi, Do buttons Add and Remove in Parameters tab have purpose? Regards, Zoran ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly      |
|
04-17-2008, 08:13 PM
| |||
| |||
| Re: Not able to add or remove argument in Parameterstab, Function Properties 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend |
|
04-17-2008, 08:13 PM
| |||
| |||
| Re: Not able to add or remove argument in Parameterstab, Function Properties 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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq |
|
04-17-2008, 08:13 PM
| |||
| |||
| Re: Not able to add or remove argument in Parameterstab, Function Properties 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 ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate |
|
04-17-2008, 08:13 PM
| |||
| |||
| Re: Not able to add or remove argument in Parameterstab, Function Properties 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org |
|
04-17-2008, 08:13 PM
| |||
| |||
| Re: Not able to add or remove argument in Parameterstab, Function Properties 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 ---------------------------(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 |
|
04-17-2008, 08:13 PM
| |||
| |||
| Re: Not able to add or remove argument in Parameterstab, Function Properties 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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq |
|
04-17-2008, 08:13 PM
| |||
| |||
| Re: Not able to add or remove argument in Parameterstab, Function Properties 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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq |
|
04-17-2008, 08:13 PM
| ||||
| ||||
| Re: Not able to add or remove argument in Parameterstab, Function Properties 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings |
Linear Mode
