Re: getProcedureColumns

[Kris Jurka <books(at)ejurka(dot)com>]

On Wed, 31 Jan 2007, Jeffrey Cox wrote:

>  I been working with metadata on stored procedures and discovered that I 
> can't get parameter names via getProcedureColumns. So i checked out the 
> source and took a look at the method. Seems that for column names, a $ is 
> appended to the arg type count. I guess I don't know if there is a reason 
> that the actual parameter names are not used, or its just low on the TODO 
> list. I went ahead and updated the method return column names as stored in 
> procargnames of pg_catalog.pg_proc. I have attached a patch.

It just hasn't been updated in a while.

> I honestly don't know if this is the correct mechanism to handle this (I 
> poped into #postgres and was told to attach a patch to an email to this 
> list), so just point me in the right direction if need be (either on how to 
> submit the patch, or why making this change is stupid).

This is exactly the place to send it.  Any chance we can also convince you 
to add a test case and fix COLUMN_TYPE for out parameters?

Kris Jurka