MIME-Version: 1.0
From: Karl Aschbacher <krlschbchr@gmail.com>
Date: Tue, 4 Jul 2023 11:09:24 +0200
Message-ID: 
 <CAADAuhCn1vqwwsFAa4BmJaXLoNdk1OEj1u+-4pp37yEWaqy5MQ@mail.gmail.com>
Subject: Change the name of a function in the odbc-driver
To: pgsql-odbc@postgresql.org
Content-Type: multipart/alternative; boundary="00000000000052274e05ffa5a43e"
Archived-At: 
 <https://www.postgresql.org/message-id/CAADAuhCn1vqwwsFAa4BmJaXLoNdk1OEj1u%2B-4pp37yEWaqy5MQ%40mail.gmail.com>
Precedence: bulk

--00000000000052274e05ffa5a43e
Content-Type: text/plain; charset="UTF-8"

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

--00000000000052274e05ffa5a43e
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Dear all,<div><br></div><div>we are using the Oracle Analy=
tics Server to connect to a PostgreSql Database.</div><div>While this is ge=
nerally working, the OAS sends some wrong function names.</div><div>(for ex=
ample grouping_id instead of grouping).</div><div>We tried creating an &quo=
t;alias function&quot;, named grouping_id that would simply call grouping, =
but we failed as the number (and type) of arguments is just not predictable=
.</div><div><br></div><div>I then came up with the idea to change the metho=
d name in the ODBC Driver, like for some scalar functions. So far I have ad=
ded another mapping in convert.c, recompiled the driver, but (of course ?) =
this is not working yet.</div><div><br></div><div>&quot;=C2=A0{&quot;GROUPI=
NG_ID&quot;, =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0&quot;grouping&quot; =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 },&quot;</div><div><br></div><div=
>So my questions are:</div><div>Is this an approach that is worth following=
?</div><div>(Knowing Oracle support, a fix might be taking quite some time)=
</div><div>If yes, is there any advice you could give what else need to be =
changed?<br></div><div><br></div><div>If no - any other idea how to address=
 this issue?</div><div>Any help or ideas will be very much appreciated.</di=
v><div><br></div><div>many thanks</div><div>best regards</div><div>Karl</di=
v><div><br></div><div><br></div><div><br></div><div><br></div><div><br></di=
v><div><br></div><div><br></div><div><br></div><div><br></div></div>

--00000000000052274e05ffa5a43e--