Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iXLlH-0000FY-SO for pgsql-bugs@arkaria.postgresql.org; Wed, 20 Nov 2019 08:54:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iXLlG-0000ub-ME for pgsql-bugs@arkaria.postgresql.org; Wed, 20 Nov 2019 08:54:54 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iXLlG-0000uU-AY for pgsql-bugs@lists.postgresql.org; Wed, 20 Nov 2019 08:54:54 +0000 Received: from out1-smtp.messagingengine.com ([66.111.4.25]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1iXLlD-00067g-Qu for pgsql-bugs@lists.postgresql.org; Wed, 20 Nov 2019 08:54:53 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id 08A8222411; Wed, 20 Nov 2019 03:54:51 -0500 (EST) Received: from mailfrontend2 ([10.202.2.163]) by compute4.internal (MEProxy); Wed, 20 Nov 2019 03:54:51 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm3; bh=NTeZVS4XcPboUCD+YtW8w41gES+ 1vcP+3Eo2BPUxLwY=; b=mJoAq3uAJ3k+TLawZm+9pmp2bewbtbo05Pdz66Gu9JM S9NjVZErPti4Zh/hrDEFv2sf5rEcPcMCLdvIDsusEZGl4YLgrIggnObjUgSxdLLD v0Mgt4W+XKDXu81rDjW5TJ+w6a1ImBpcuBU5OAimXO+hkMxd0BYGAALGw6jrd8u2 UFg3eTR2E9ovp5AXaYfeYUC+pbPyfOFVuSL5YBZsrmLtaS/ByFgZBYRxAesjm1oV 60mcsqFvOs4yNBUK+1Z2C3oLyIABS39zZLMmKxfGRlpZ2fvYTnOIhE25fBRr7+jL QcmScoXzWRj2UAu3928WssNooS936G/vNIuYv1E5Nuw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; bh=NTeZVS 4XcPboUCD+YtW8w41gES+1vcP+3Eo2BPUxLwY=; b=pj2hbMBssFXci9zl8SjVdB e1wUfsTLYlbKWs6m+8CM8zaxpwODaN8NIOZZHiChoTV6JlQp7c+f7LsH/BUeBUR+ s9OizcK+wNkNaz7vUxgLduNisf1ZXGwcWtvlRb3RjKh4Bx8Apbh14ZX9/M7F3G1l WL4LShJvDJIEQe2bpasf606luLkLKlGj7ZCevYtB5gRhMmltKzpN+s5v2qiP1URH pQy+iRL+0sTAFIr/FD8GLK3N/nJRUyrQ34vYUACD2FFNrwmMJrhlXr3MA1gZMDy2 HVxnFrQBp0gpAMT1chz+0KK/xii1JfkMdipVQyoPaEeKksx9P5owraBZS6nhRouQ == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedufedrudegledguddvhecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfgh necuuegrihhlohhuthemuceftddtnecufghrlhcuvffnffculdefhedmnecujfgurhepff fhvffukfhfgggtuggjsehgtderredttddvnecuhfhrohhmpefoihgthhgrvghlucfrrghq uhhivghruceomhhitghhrggvlhesphgrqhhuihgvrhdrgiihiieqnecuffhomhgrihhnpe hmihgtrhhoshhofhhtrdgtohhmnecukfhppeduuddurddutddvrddukedtrddukeehnecu rfgrrhgrmhepmhgrihhlfhhrohhmpehmihgthhgrvghlsehprghquhhivghrrdighiiine cuvehluhhsthgvrhfuihiivgeptd X-ME-Proxy: Received: from paquier.xyz (ee0822lan1.rev.em-net.ne.jp [111.102.180.185]) by mail.messagingengine.com (Postfix) with ESMTPA id 8BC2B306005F; Wed, 20 Nov 2019 03:54:49 -0500 (EST) Date: Wed, 20 Nov 2019 17:54:41 +0900 From: Michael Paquier To: jadhavprasad57@gmail.com, pgsql-bugs@lists.postgresql.org Subject: Re: BUG #16126: Missing the sp_OACreate procedures Message-ID: <20191120085441.GA153437@paquier.xyz> References: <16126-3fab1b7bfd63c659@postgresql.org> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="Kj7319i9nmIyA2yE" Content-Disposition: inline In-Reply-To: <16126-3fab1b7bfd63c659@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --Kj7319i9nmIyA2yE Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable 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. >=20 > Does PostgreSQL OA extended procedure ? or any equivalent objects? Looking here: https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-pro= cedures/sp-oacreate-transact-sql?view=3Dsql-server-ver15 The answer is no. -- Michael --Kj7319i9nmIyA2yE Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl3U/1EACgkQnvQgOdby QH1ZtxAAnysES2lyUBPHub4gHp22OhHQED4xEFTdd4ALhvhX9LEG1VoQwmQl/uIq cPrXAyl6IqxxoBuuMnzJh9AEHtaNMgtjxsF4IvZFdoBB1p1jXWLtZ3U4pW0TCi8Z ctX1/vZBzThZPnl9iRjfUpQxUs0kctq/XQZHPYKM985GQ+9UfxRB5PPv4O5Osmh5 FfbXFT7K7hbBa2oVbpsZn4M5U+tG6pYhwnEh4cJCeI7our12pdDUZLBmMuXpkacr 5BaqlDm6nQF9lX7kGi75ACMPqP+wtaMVIN7wkWxJG3XYT0IBpd2Cp0pCWTxoRIZD +IGZOLKRd9F8/S2H8Lwy8ER+tydN8QeKZIyzMQhf0jaKJIR9FLI816INq6wNQQ0Z THV4SPpIcKfmmtAlu2iMAy1h26sbDmYrBkf11I7i6pumOENLAjbJ0jp6ZoeJpzkH QgL1djL8ZYbFVy81x+KWuAjLt3++24+pSi8yPpOIN703tt+XlwYqgBFiR/jrHX2h K9tAKMIAeZ/A7sZUDRyyxzWglKYLVNfrqUefWPIM9Y9ll1KMd0iJ7OhuHSkmh7tm i1jziIT3kCZa0dxOUwBHu1wdSNNxdsnIWGLaIMomWXNK8vnIDOg4by9Uxlyekht7 QNdRzukXK6gRUy1oKm4iio8Wn3uxdcm65qxhacod86GDUpANMII= =mgpr -----END PGP SIGNATURE----- --Kj7319i9nmIyA2yE--