public inbox for [email protected]  

help / color / mirror / Atom feed

From: Dave Cramer <[email protected]>
To: 刘庄 <[email protected]>
Cc: [email protected]
Subject:  Re: [PATCH] Allow catalogname (database) and procname （no under public schema) enumeration with SQLProcedures
Date: Tue, 10 Oct 2023 09:04:31 -0400
Message-ID: <CADK3HHKTpZ=X3kOWO8hMvuq7fdkCuPL5ZXy5+PixwrxzrpOK2Q@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>

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, 刘庄 <[email protected]> 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:
>
>
>
>
>
>


Attachments:

  [image/png] image.png (3.3K, 3-image.png)
  download | view image

  [image/png] image.png (6.7K, 4-image.png)
  download | view image

  [image/png] image.png (3.3K, 5-image.png)
  download | view image

view thread (3+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re:  Re: [PATCH] Allow catalogname (database) and procname （no under public schema) enumeration with SQLProcedures
  In-Reply-To: <CADK3HHKTpZ=X3kOWO8hMvuq7fdkCuPL5ZXy5+PixwrxzrpOK2Q@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox