Re: BUG #15740: Problem with the creation of prodecures, synonyms and packages

Hi,
Many thanks for your answer.
I would have sworn I had already written procedures for postgresql.

Regards.
André Miralles.

Le 08/04/2019 à 15:41, Pavel Stehule a écrit :

Hi

po 8. 4. 2019 v 14:50 odesílatel PG Bug reporting form <noreply@postgresql.org> napsal:

The following bug has been logged on the website:

Bug reference:      15740
Logged by:          André Miralles
Email address:      dedes.miralles@free.fr
PostgreSQL version: 10.7
Operating system:   windows
Description:       

Dear Sir,
I cannot create prodecures, synonyms and packages on the different versions
of servers?
Is it a bug? pgAdmin or PostGreSQL ?
I remember that I could do it before.
I contact you because I have not found an answer on the internet.

No it is not a bug. PostgreSQL is not Oracle, and is not compatible with Oracle.

Procedures are supported from PostgreSQL 11, synonyms and packages are not supported. Instead synonyms you can set SEARCH_PATH variable and views. Use schemas instead packages.

You can find lot of sources about migration from Oracle to Postgres.

 

Regards

Pavel Stehule

Regards.
André.