Change the name of a function in the odbc-driver

From: Karl Aschbacher <krlschbchr(at)gmail(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Change the name of a function in the odbc-driver
Date: 2023-07-04 09:09:24
Message-ID: CAADAuhCn1vqwwsFAa4BmJaXLoNdk1OEj1u+-4pp37yEWaqy5MQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Dear all,

we are using the Oracle Analytics Server to connect to a PostgreSql
Database.
While this is generally working, the OAS sends some wrong function names.
(for example grouping_id instead of grouping).
We tried creating an "alias function", named grouping_id that would simply
call grouping, but we failed as the number (and type) of arguments is just
not predictable.

I then came up with the idea to change the method name in the ODBC Driver,
like for some scalar functions. So far I have added another mapping in
convert.c, recompiled the driver, but (of course ?) this is not working yet.

" {"GROUPING_ID", "grouping" },"

So my questions are:
Is this an approach that is worth following?
(Knowing Oracle support, a fix might be taking quite some time)
If yes, is there any advice you could give what else need to be changed?

If no - any other idea how to address this issue?
Any help or ideas will be very much appreciated.

many thanks
best regards
Karl

Browse pgsql-odbc by date

  From Date Subject
Next Message Ketop 2023-07-11 05:29:37 psqlodbc multibyte.c setlocale(LC_CTYPE, 0) make process unable to use cregex to process chineses.
Previous Message Robert Willis 2023-07-03 17:19:35 ODBC driver changes