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

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

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:      [hidden email]
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é.

Reply | Threaded
Open this post in threaded view
|

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 <[hidden email]> napsal:
The following bug has been logged on the website:

Bug reference:      15740
Logged by:          André Miralles
Email address:      [hidden email]
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é.

Reply | Threaded
Open this post in threaded view
|

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

André Free
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 <[hidden email]> napsal:
The following bug has been logged on the website:

Bug reference:      15740
Logged by:          André Miralles
Email address:      [hidden email]
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é.

Reply | Threaded
Open this post in threaded view
|

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 <[hidden email]> 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 <[hidden email]> napsal:
The following bug has been logged on the website:

Bug reference:      15740
Logged by:          André Miralles
Email address:      [hidden email]
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é.