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

Hi

po 8. 4. 2019 v 14:50 odesílatel PG Bug reporting form <
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
> 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é.
>
>