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

po 8. 4. 2019 v 15:56 odesílatel André Free <dedes(dot)miralles(at)free(dot)fr> napsal:

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

Maybe you wrote a functions, - these are supported ages.

Pavel

> 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> 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é.
>>
>>