orafunc > orafce

[x...@thebuild.com]

I have a PostgreSQL 9.2 database that I'd like to upgrade from orafunc to the latest orafce. Is there a standard way of handling this? Any advice?

[Pavel Stehule]

Hi

2016-04-09 1:24 GMT+02:00 <x...@thebuild.com>:

I have a PostgreSQL 9.2 database that I'd like to upgrade from orafunc to the latest orafce. Is there a standard way of handling this? Any advice?

It depends how old orafce lib you have. Currently ALTER EXTENSION UPDATE is not supported, so you have to drop orafce and recreate orafce.

DROP EXTENSION orafce;

CREATE EXTENSION orafce;

Regards

Pavel

--
You received this message because you are subscribed to the Google Groups "Better Oracle functions support" group.
To post to this group, send email to orafce-...@googlegroups.com.
Visit this group at https://groups.google.com/group/orafce-general.

[Christophe Pettus]

On Apr 8, 2016, at 8:54 PM, Pavel Stehule <pavel....@gmail.com> wrote:

> It depends how old orafce lib you have. Currently ALTER EXTENSION UPDATE is not supported, so you have to drop orafce and recreate orafce.

Thanks! To what extent is orafce upwards compatible with orafunc?

--
-- Christophe Pettus
x...@thebuild.com

[Pavel Stehule]

2016-04-09 6:06 GMT+02:00 Christophe Pettus <x...@thebuild.com>:

On Apr 8, 2016, at 8:54 PM, Pavel Stehule <pavel....@gmail.com> wrote:

> It depends how old orafce lib you have. Currently ALTER EXTENSION UPDATE is not supported, so you have to drop orafce and recreate orafce.

Thanks!  To what extent is orafce upwards compatible with orafunc?

Orafunc and Orafce are synonyms. There is continual enhancing.

Pavel
 

--
-- Christophe Pettus
   x...@thebuild.com

[PAscal L]

Hi,

do not drop orafce extension if you have VARCHAR2 datatypes ... it drops all the corresponding columns ;0(

PAscal