From: | Prasad Jadhav <jadhavprasad57(at)gmail(dot)com> |
---|---|
To: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
Cc: | PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
Subject: | Re: BUG #16126: Missing the sp_OACreate procedures |
Date: | 2019-11-20 10:09:34 |
Message-ID: | CADwcMOd7mi0S5H9MOWSymTbhnf1mo3xRyFCz7myK-Yf1iyMZTA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Thank you for your prompt response,
On Wed, Nov 20, 2019 at 3:23 PM Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
wrote:
> Hi
>
> st 20. 11. 2019 v 9:51 odesílatel PG Bug reporting form <
> noreply(at)postgresql(dot)org> napsal:
>
>> The following bug has been logged on the website:
>>
>> Bug reference: 16126
>> Logged by: Prasad Jadhav
>> Email address: jadhavprasad57(at)gmail(dot)com
>> PostgreSQL version: 12.1
>> Operating system: Windows
>> Description:
>>
>
>
>
>>
>> Hi,
>>
>> I am migrating my MS SQL databases to PostgresSQL. I wish to convert one
>> stored procedure from SQL server to PostgreSQL. But I couldn't find the
>> compatibility for 'sp_OACreate' extended procedure.
>>
>> Does PostgreSQL OA extended procedure ? or any equivalent objects?
>>
>
> This is not bug. Postgres doesn't supports COM objects, because it is
> multiplatform project, and COM objects are +/- MS platform only technology.
>
> Postgres has own API that can be used for extensions -
> https://www.postgresql.org/docs/current/server-programming.html
>
> When you have knowledge of C programming, then you can use it. If not,
> then you can use Python or Perl interface.
>
> Pavel
>
From | Date | Subject | |
---|---|---|---|
Next Message | Manuel Rigger | 2019-11-20 12:42:30 | ALTER TABLE fails when changing column type due to index with bit_ops opclass |
Previous Message | Pavel Stehule | 2019-11-20 09:52:53 | Re: BUG #16126: Missing the sp_OACreate procedures |