cancel
Showing results for 
Search instead for 
Did you mean: 

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

 

 

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
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

 

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.

3 REPLIES 3
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

 

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.

Gold Adventurer

Re: problem with synonym for packages in 9.6 advanced server

haa, okok, good

thanks for your quick response

 

regards