Does orafce PostgreSQL extension support PG version 16

[Harkirat Singh]

I would like to know if the orafce extension supports the new PostgreSQL version 16 yet and if so is it available for Azure PostgreSQL DB to install there. Thanks.

[Pavel Stehule]

Hi

so 4. 1. 2025 v 14:34 odesílatel Harkirat Singh <harki...@gmail.com> napsal:

I would like to know if the orafce extension supports the new PostgreSQL version 16 yet and if so is it available for Azure PostgreSQL DB to install there. Thanks.

https://learn.microsoft.com/en-us/azure/postgresql/extensions/concepts-extensions-by-engine?pivots=postgresql-16

Orafce is there

Regards

Pavel

 

--
You received this message because you are subscribed to the Google Groups "Better Oracle functions support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to orafce-genera...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/orafce-general/ddf478c7-b877-4e92-ac87-4fc6fd7f2fddn%40googlegroups.com.

[Harkirat Singh]

Thank you!

[Harkirat Singh]

We installed the extension but it does not appear to be working. Keeps throwing error function does not exists if i do something simple like

select nvl(null,1)

It was working fine in postgres ver 13 and then we did an inplace upghrade to ver 16 and now it wont work even after reinstalling it.

We made sure it was on ver 4.4. which is supported by Postegre 16.

Any ideas?

[Pavel Stehule]

út 7. 1. 2025 v 12:21 odesílatel Harkirat Singh <harki...@gmail.com> napsal:

We installed the extension but it does not appear to be working. Keeps throwing error function does not exists if i do something simple like

select nvl(null,1)

It was working fine in postgres ver 13 and then we did an inplace upghrade to ver 16 and now it wont work even after reinstalling it.

We made sure it was on ver 4.4. which is supported by Postegre 16.

Any ideas?

Orafce supports pg 12+ . But you need to use Orafce compiled for Postgres 16. PostgreSQL extensions are compiled for specific major release, and cannot be used for any other release. So you cannot to use Orafce compiled for pg13 in pg16.

 

On Sunday, January 5, 2025 at 12:49:35 AM UTC+5:30 Harkirat Singh wrote:

Thank you!

On Saturday, January 4, 2025 at 7:06:34 PM UTC+5:30 Pavel Stehule wrote:

Hi

so 4. 1. 2025 v 14:34 odesílatel Harkirat Singh <harki...@gmail.com> napsal:

I would like to know if the orafce extension supports the new PostgreSQL version 16 yet and if so is it available for Azure PostgreSQL DB to install there. Thanks.

https://learn.microsoft.com/en-us/azure/postgresql/extensions/concepts-extensions-by-engine?pivots=postgresql-16

Orafce is there

Regards

Pavel

 

--
You received this message because you are subscribed to the Google Groups "Better Oracle functions support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to orafce-genera...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/orafce-general/ddf478c7-b877-4e92-ac87-4fc6fd7f2fddn%40googlegroups.com.

--
You received this message because you are subscribed to the Google Groups "Better Oracle functions support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to orafce-genera...@googlegroups.com.

To view this discussion visit https://groups.google.com/d/msgid/orafce-general/25eaec89-11e8-46ef-9f41-b47456878577n%40googlegroups.com.