getProcedureColumns

From: Jeffrey Cox <namredips(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: getProcedureColumns
Date: 2007-01-31 08:29:51
Message-ID: 1C85230A-C17D-4601-B84E-6F43176C5D6D@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi,
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.

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

Jeff

Attachment Content-Type Size
postgres-jdbc-patch.rtf text/rtf 2.8 KB

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2007-01-31 21:20:52 Re: getProcedureColumns
Previous Message Kris Jurka 2007-01-30 19:50:52 Re: please