Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #15740: Problem with the creation of prodecures, synonyms andpackages - Mailing list pgsql-bugs

From André Free
Subject Re: BUG #15740: Problem with the creation of prodecures, synonyms andpackages
Date
Msg-id 4e89c822-b394-22c8-9fca-dad22eb54a2a@free.fr
Whole thread Raw
In response to Re: BUG #15740: Problem with the creation of prodecures, synonyms and packages  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-bugs
Tree view
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 <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é.

pgsql-bugs by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: BUG #15740: Problem with the creation of prodecures, synonyms and packages
Next
From: Pavel Stehule
Date:
Subject: Re: BUG #15740: Problem with the creation of prodecures, synonyms and packages