| From: | 刘庄 <lzwp0521(at)163(dot)com> |
|---|---|
| To: | pgsql-odbc(at)postgresql(dot)org |
| Subject: | [PATCH] Allow catalogname (database) and procname （no under public schema) enumeration with SQLProcedures |
| Date: | 2023-10-10 05:09:01 |
| Message-ID: | 755f8640.2ea4.18b17fd0ce5.Coremail.lzwp0521@163.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 | Content-Type | Size |
|---|---|---|
| AllCatalogsProcname-SQLProcedures.patch | application/octet-stream | 696 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Cramer | 2023-10-10 13:04:31 | Re: [PATCH] Allow catalogname (database) and procname （no under public schema) enumeration with SQLProcedures |
| Previous Message | Brad White | 2023-10-03 21:51:34 | ODBC options |