pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
BUG #16126: Missing the sp_OACreate procedures
4+ messages / 4 participants
[nested] [flat]

* BUG #16126: Missing the sp_OACreate procedures
@ 2019-11-20 08:50  PG Bug reporting form <noreply@postgresql.org>
  0 siblings, 2 replies; 4+ messages in thread

From: PG Bug reporting form @ 2019-11-20 08:50 UTC (permalink / raw)
  To: pgsql-bugs@lists.postgresql.org; +Cc: jadhavprasad57@gmail.com

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?



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: BUG #16126: Missing the sp_OACreate procedures
@ 2019-11-20 08:54  Michael Paquier <michael@paquier.xyz>
  parent: PG Bug reporting form <noreply@postgresql.org>
  1 sibling, 0 replies; 4+ messages in thread

From: Michael Paquier @ 2019-11-20 08:54 UTC (permalink / raw)
  To: jadhavprasad57@gmail.com; pgsql-bugs@lists.postgresql.org

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-trans...
The answer is no.
--
Michael

Attachments:

  signature.asc (application/pgp-signature, 832B) download

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: BUG #16126: Missing the sp_OACreate procedures
@ 2019-11-20 09:52  Pavel Stehule <pavel.stehule@gmail.com>
  parent: PG Bug reporting form <noreply@postgresql.org>
  1 sibling, 1 reply; 4+ messages in thread

From: Pavel Stehule @ 2019-11-20 09:52 UTC (permalink / raw)
  To: jadhavprasad57@gmail.com, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>

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

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: BUG #16126: Missing the sp_OACreate procedures
@ 2019-11-20 10:09  Prasad Jadhav <jadhavprasad57@gmail.com>
  parent: Pavel Stehule <pavel.stehule@gmail.com>
  0 siblings, 0 replies; 4+ messages in thread

From: Prasad Jadhav @ 2019-11-20 10:09 UTC (permalink / raw)
  To: Pavel Stehule <pavel.stehule@gmail.com>; +Cc: PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>

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
>

^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2019-11-20 10:09 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2019-11-20 08:50 BUG #16126: Missing the sp_OACreate procedures PG Bug reporting form <noreply@postgresql.org>
2019-11-20 08:54 ` Michael Paquier <michael@paquier.xyz>
2019-11-20 09:52 ` Pavel Stehule <pavel.stehule@gmail.com>
2019-11-20 10:09   ` Prasad Jadhav <jadhavprasad57@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox