Re: getProcedureColumns - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: getProcedureColumns
Date
Msg-id Pine.BSO.4.64.0701311619160.27765@leary2.csoft.net
Whole thread Raw
In response to getProcedureColumns  (Jeffrey Cox <namredips@gmail.com>)
Responses Re: getProcedureColumns
List pgsql-jdbc

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

pgsql-jdbc by date:

Previous
From: Jeffrey Cox
Date:
Subject: getProcedureColumns
Next
From: Jeffrey Cox
Date:
Subject: Re: getProcedureColumns