Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #16126: Missing the sp_OACreate procedures - Mailing list pgsql-bugs

From Prasad Jadhav
Subject Re: BUG #16126: Missing the sp_OACreate procedures
Date
Msg-id CADwcMOd7mi0S5H9MOWSymTbhnf1mo3xRyFCz7myK-Yf1iyMZTA@mail.gmail.com
Whole thread Raw
In response to Re: BUG #16126: Missing the sp_OACreate procedures  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-bugs
Tree view
Thank you for your prompt response,

On Wed, Nov 20, 2019 at 3:23 PM Pavel Stehule <pavel.stehule@gmail.com> wrote:
Hi

st 20. 11. 2019 v 9:51 odesílatel PG Bug reporting form <noreply@postgresql.org> napsal:
The following bug has been logged on the website:

Bug reference:      16126
Logged by:          Prasad Jadhav
Email address:      jadhavprasad57@gmail.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

pgsql-bugs by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: BUG #16126: Missing the sp_OACreate procedures
Next
From: Manuel Rigger
Date:
Subject: ALTER TABLE fails when changing column type due to index with bit_ops opclass