Thread: BUG #16126: Missing the sp_OACreate procedures
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?
On Wed, Nov 20, 2019 at 08:50:29AM +0000, PG Bug reporting form wrote: > 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? Looking here: https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-oacreate-transact-sql?view=sql-server-ver15 The answer is no. -- Michael
Attachment
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
Thank you for your prompt response,
On Wed, Nov 20, 2019 at 3:23 PM Pavel Stehule <pavel.stehule@gmail.com> wrote:
Hist 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.htmlWhen you have knowledge of C programming, then you can use it. If not, then you can use Python or Perl interface.Pavel