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.