|
Home > Archive > Pgadmin > September 2005 > Bug/Feature request: Parameter names
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Bug/Feature request: Parameter names
|
|
| Bath, David 2005-09-21, 8:24 pm |
| Folks,
Version of pgadmin3 : 1.2.2
Version of postgresql : 8.0.3
Operating Platform : SuSE 9.3 Professional IA-32
Summary: Loss of parameter names in functions
Impact (1-10): 7
Long Description:
I am having difficulties with function parameter names:
a. Entering them through the properties/create new dialog boxes
b. Parameter names are missing when retrieved into SQL panel.
Item (b) seems especially odd, as I note that this information
*is* available in the following columns/attributes
a. information_schema.parameter.parameter_name
b. pg_catalog.pg_proc.proargnames
I am using pgadmin3 for rapid development, and this slows me
down considerably, especially.
Thanks in advance
--
David T. Bath
dave.bath@unix.net
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
| |
| Dave Page 2005-09-22, 3:24 am |
|
> -----Original Message-----
> From: pgadmin-support-owner@postgresql.org
> [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Bath, David
> Sent: 22 September 2005 01:42
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] Bug/Feature request: Parameter names
>
> Folks,
>
> Version of pgadmin3 : 1.2.2
> Version of postgresql : 8.0.3
> Operating Platform : SuSE 9.3 Professional IA-32
> Summary: Loss of parameter names in functions
> Impact (1-10): 7
>
> Long Description:
> I am having difficulties with function parameter names:
> a. Entering them through the properties/create new dialog boxes
> b. Parameter names are missing when retrieved into SQL panel.
>
> Item (b) seems especially odd, as I note that this information
> *is* available in the following columns/attributes
> a. information_schema.parameter.parameter_name
> b. pg_catalog.pg_proc.proargnames
>
> I am using pgadmin3 for rapid development, and this slows me
> down considerably, especially.
Named parameters are supported in the current development code which is
shortly going to become a beta. You can download snapshots from
http://developer.pgadmin.org/snapshots/, however you'll need to compile
from source for Suse I'm afraid.
Regards, Dave
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
| |
| Andreas Pflug 2005-09-22, 7:23 am |
| Dave Page wrote:
>
> Named parameters are supported in the current development code which is
> shortly going to become a beta.
It's in 1.2 as well, so the missing reengineered name might be a bug.
1.2.2 is probably the last 1.2 version, so we'll check this in 1.3
Regards,
Andreas
---------------------------(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
| |
|
|
|
|
|