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

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)
<https://github.com/postgresql-interfaces/psqlodbc> and add tests please ?

Dave Cramer
www.postgres.rocks

On Tue, 10 Oct 2023 at 01:09, 刘庄 <lzwp0521(at)163(dot)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:
>
>
>
>
>
>