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(at)postgresql(dot)org <mailto:noreply(at)postgresql(dot)org>> napsal:
>
> The following bug has been logged on the website:
>
> Bug reference:      15740
> Logged by:          André Miralles
> Email address: dedes(dot)miralles(at)free(dot)fr <mailto:dedes(dot)miralles(at)free(dot)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é.
>