Postgres Pro
Downloads
Home   >   mailing lists

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

From Dave Cramer
Subject Re: [PATCH] Allow catalogname (database) and procname （no under public schema) enumeration with SQLProcedures
Date
Msg-id CADK3HHKTpZ=X3kOWO8hMvuq7fdkCuPL5ZXy5+PixwrxzrpOK2Q@mail.gmail.com
Whole thread Raw
In response to [PATCH] Allow catalogname (database) and procname （no under public schema) enumeration with SQLProcedures  (刘庄 <lzwp0521@163.com>)
Responses Re:Re: [PATCH] Allow catalogname (database) and procname （no under public schema) enumeration with SQLProcedures
List pgsql-odbc
Tree view
Hello,

Thanks for the patch, however it does not apply cleanly using patch or git apply

Can you provide a PR postgresql-interfaces/psqlodbc (github.com) and add tests please ?


Dave Cramer
www.postgres.rocks


On Tue, 10 Oct 2023 at 01:09, 刘庄 <lzwp0521@163.com> wrote:

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: 刘庄
Date:
Subject: [PATCH] Allow catalogname (database) and procname （no under public schema) enumeration with SQLProcedures
Next
From: 刘庄
Date:
Subject: Re:Re: [PATCH] Allow catalogname (database) and procname （no under public schema) enumeration with SQLProcedures