java.sql.DatabaseMetaData.getProcedures and overloaded functions

From: Thor Michael Støre <thormichael(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: java.sql.DatabaseMetaData.getProcedures and overloaded functions
Date: 2010-12-30 19:47:14
Message-ID: 1293738434.11427.34.camel@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Is my understanding correct in that JDBC doesn't actually provide a
proper way of inspecting overloaded stored procedures, and so to get
that information reliably you should query the PostgreSQL system
catalogs? At least when I try to use the java.sql.DatabaseMetaData
getProcedures and getProcedureColumns methods on overloaded procedures I
see them repeated without any explicit distinction between them, except
of course that getProcedureColumns gives different datatypes for each
procedure.

Thanks,
Thor Michael Støre

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2010-12-31 03:24:20 Re: java.sql.DatabaseMetaData.getProcedures and overloaded functions
Previous Message Craig Ringer 2010-12-30 06:32:32 Re: Client-Side triggers possible?