From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | jadhavprasad57(at)gmail(dot)com, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
Subject: | Re: BUG #16126: Missing the sp_OACreate procedures |
Date: | 2019-11-20 09:52:53 |
Message-ID: | CAFj8pRCX_-1F_c+7-HPbPLpB6jtx1nJ0HGA26+ZingK52pD5RA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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 | Prasad Jadhav | 2019-11-20 10:09:34 | Re: BUG #16126: Missing the sp_OACreate procedures |
Previous Message | Michael Paquier | 2019-11-20 08:54:41 | Re: BUG #16126: Missing the sp_OACreate procedures |