Обсуждение: BUG #15740: Problem with the creation of prodecures, synonyms and packages
BUG #15740: Problem with the creation of prodecures, synonyms and packages
От
PG Bug reporting form
Дата:
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. Regards. André.
Re: BUG #15740: Problem with the creation of prodecures, synonyms and packages
От
Pavel Stehule
Дата:
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é.
Hi,
Many thanks for your answer.
I would have sworn I had already written procedures for postgresql.
Regards.
André Miralles.
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 :
Hipo 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.RegardsPavel StehuleRegards.
André.
Re: BUG #15740: Problem with the creation of prodecures, synonyms and packages
От
Pavel Stehule
Дата:
po 8. 4. 2019 v 15:56 odesílatel André Free <dedes.miralles@free.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 :Hipo 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.RegardsPavel StehuleRegards.
André.