BUG #15740: Problem with the creation of prodecures, synonyms and packages
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é.
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
Show quoted text
Regards.
André.
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 :
Show quoted text
Hi
po 8. 4. 2019 v 14:50 odesílatel PG Bug reporting form
<noreply@postgresql.org <mailto: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 <mailto: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 Stehule
Regards.
André.
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
Show quoted text
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é.