[PATCH] Allow catalogname (database) and procname (no under public schema) enumeration with SQLProcedures - Mailing list pgsql-odbc

From 刘庄
Subject [PATCH] Allow catalogname (database) and procname (no under public schema) enumeration with SQLProcedures
Date
Msg-id 755f8640.2ea4.18b17fd0ce5.Coremail.lzwp0521@163.com
Whole thread Raw
Responses Re: [PATCH] Allow catalogname (database) and procname (no under public schema) enumeration with SQLProcedures
List pgsql-odbc

hello!


The attached patch fixed  SQLProcedures two bug:

1.  make enumeration of databases (catalogs in ODBC speak) work.

2.  make enumeration of procedurename (procname  in ODBC speak) work.



Step:

   1.  login postgres

   2.  create schem named  schem1 

   3.  set search_path TO schem1

   4.  create procedure named genre_insert_data

   5.  with odbc application(retcode =  SQLProcedures (hstmt, NULL, 0, NULL, 0, (SQLCHAR *)"genre_insert_data", strlen("genre_insert_data"));)to get the genre_insert_data(step 4)

   6.  the result is empty.

   
   7. After the patch is compiled using the attached patch, then run the odbc application(step 5), The result is shown below:
     



  
Attachment

pgsql-odbc by date:

Previous
From: Brad White
Date:
Subject: ODBC options
Next
From: Dave Cramer
Date:
Subject: Re: [PATCH] Allow catalogname (database) and procname (no under public schema) enumeration with SQLProcedures