problem with synonym for packages in 9.6 advanced server

SOLVED
Highlighted
Gold Adventurer

problem with synonym for packages in 9.6 advanced server

Hi all, the doc (

https://www.enterprisedb.com/docs/en/9.6/DB_Compat_Oracle_Developers_Guide/Database_Compatibility_fo...

 ) of postgres advanced server 9.6 said that synonym in Advanced Server supports  for:

 

tables

views

materialized views

sequences

packages

procedures

functions

types

objects that are accessible through a database link

other synonyms

 

However, the following does not work, I'm missing something?

 

edb=# create synonym syno_pkg for public.emp_admin; -- public.emp_admin is the package of demo db in advanced server
CREATE SYNONYM

 

edb=# select * from pg_synonym ;
synname | synnamespace | synowner | synobjschema | synobjname | synlink
----------+--------------+----------+--------------+------------+---------
syno_pkg | 16444 | 10 | public | emp_admin |
(1 row)

-------ERROR HERE
edb=# select syno_pkg.get_dept_name(10) from dual;
ERROR: schema "syno_pkg" does not exist
LINE 1: select syno_pkg.get_dept_name(10) from dual;
^

--FAIL here too schema.syno.....

edb=# select public.syno_pkg.get_dept_name(10) from dual;
ERROR: package "syno_pkg" does not exist
LINE 1: select public.syno_pkg.get_dept_name(10) from dual;
                       ^

 --calling procedure by name of package

 

edb=# select public.emp_admin.get_dept_name(10) from dual; --here function OK
get_dept_name
---------------
ACCOUNTING
(1 row)

edb=# select version();
version
--------------------------------------------------------------------------------------------------------------
EnterpriseDB 9.6.2.7 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-16), 64-bit
(1 row)

 

 

Regards

 

 

 

 

Archived Discussions


Effective March 31st, we will no longer engage on PostgresRocks.


How to engage with us further?


  • Thought Leadership: EDB Blogs

  • Tips and Tricks: Postgres Tutorials

  • Customer Support: Create a Case Please note: Only customers with an active EDB support subscription and support portal authorization can create support ticket

  • Engage on Stackoverflow While engaging on Stackoverflow tag the question with EDB or EnterpriseDB.

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Gold Adventurer

Re: problem with synonym for packages in 9.6 advanced server

the doc of 9.5 don't said nothing about synonym for packages (https://www.enterprisedb.com/docs/en/9.5/oracompat/Database_Compatibility_for_Oracle_Developers_Guid...)

and EDB Postgres Advanced Server 9.6 release note don't said nothing new about  synonym

(https://get.enterprisedb.com/docs/EDBPostgresAdvancedServer9.6ReleaseNotes.pdf?_ga=2.155097850.33180...)

 

 

will be problem in documentation?

 

regards

 

View solution in original post

Highlighted
Moderator

Re: problem with synonym for packages in 9.6 advanced server

Hi,

Apologies for the inconvenience.

Yes, you are correct. We do not support CREATE SYNONYM for packages. The documentation of AS9.6 needs to be updated as we need to remove PACKAGES from the below link for supported objects :


https://www.enterprisedb.com/docs/en/9.6/DB_Compat_Oracle_Developers_Guide/Database_Compatibility_fo...

We have already logged a Bug #43049 to update the documentation.

View solution in original post

3 REPLIES 3
Highlighted
Gold Adventurer

Re: problem with synonym for packages in 9.6 advanced server

the doc of 9.5 don't said nothing about synonym for packages (https://www.enterprisedb.com/docs/en/9.5/oracompat/Database_Compatibility_for_Oracle_Developers_Guid...)

and EDB Postgres Advanced Server 9.6 release note don't said nothing new about  synonym

(https://get.enterprisedb.com/docs/EDBPostgresAdvancedServer9.6ReleaseNotes.pdf?_ga=2.155097850.33180...)

 

 

will be problem in documentation?

 

regards

 

View solution in original post

Highlighted
Moderator

Re: problem with synonym for packages in 9.6 advanced server

Hi,

Apologies for the inconvenience.

Yes, you are correct. We do not support CREATE SYNONYM for packages. The documentation of AS9.6 needs to be updated as we need to remove PACKAGES from the below link for supported objects :


https://www.enterprisedb.com/docs/en/9.6/DB_Compat_Oracle_Developers_Guide/Database_Compatibility_fo...

We have already logged a Bug #43049 to update the documentation.

View solution in original post

Highlighted
Gold Adventurer

Re: problem with synonym for packages in 9.6 advanced server

haa, okok, good

thanks for your quick response

 

regards

© 2019 EnterpriseDB Corporation. All rights reserved.   |   Privacy Policy   |  Terms of Use   |   Trademarks