Postgres Pro
Downloads
Home   >   mailing lists

Re: Support for PostgreSQL stored procedure through ITX. - Mailing list pgsql-sql

From Tom Lane
Subject Re: Support for PostgreSQL stored procedure through ITX.
Date
Msg-id 2091963.1625838165@sss.pgh.pa.us
Whole thread Raw
In response to Support for PostgreSQL stored procedure through ITX.  (Prajakta Chinchole <prajakta.chinchole@hcl.com>)
List pgsql-sql
Tree view 
Prajakta Chinchole <prajakta.chinchole@hcl.com> writes:
> We are trying to execute a PostgreSQL stored procedure through ITX. We are using ODBC driver that was provided with
PostgreSQL.We observed that sqlExecDirect() failed for stored procedure with below error : 
>                DIAG [42809] ERROR: public.transfer(integer, integer) is a procedure;
> Error while executing the query (1)

You might have more luck asking about this on the pgsql-odbc mailing list.
Also, make sure you're using an up-to-date release of the ODBC driver.

            regards, tom lane

pgsql-sql by date:

Previous
From: Prajakta Chinchole
Date:
Subject: Support for PostgreSQL stored procedure through ITX.
Next
From: Rob Sargent
Date:
Subject: Re: Sort a table by a column value that is a column name?