[GENERAL] Synonyms in PostgreSQL 9.2.4

couple of users. They own tables, views, and other objects. We create synonyms for a given object ,grant needed privilege and provide those synonyms to the users other than the owners. Is there any work-around you could suggest in PostgreSQL? Thanks in advance,Panneerselvam Posangu

[GENERAL] Synonyms in PostgreSQL 9.2.4

couple of users. They own tables, views, and other objects. We create synonyms for a given object ,grant needed privilege and provide those synonyms to the users other than the owners. Is there any work-around you could suggest in PostgreSQL? Thanks in advance,Panneerselvam Posangu

[GENERAL] Oracle Packages and Stored Procedures - PostgreSQL conversion

new to PostgreSQL; hence seeking some help from larger group of experts. Currently I try to understand the suggestions from 9.2.4 documentation here: http://www.postgresql.org/docs/9.2/static/plpgsql-porting.html Thanks in advance,Panneerselvam Posangu

[GENERAL] SQL State XX000 : XML namespace issue

Hi, When we run a SQL statement in Postgres 9.2 we get an error. Error : Could not register XML namespace with name "" and URI "" SQL State XX000 In the SQL state we use xpath function. Any reason why this is happening.. Thanks,Panneer

Re: [GENERAL] SQL State XX000 : XML namespace issue

MLPARSE (CONTENT p.ATTRIBUTES)),ARRAY[ARRAY['', '']]) ),'','')),'9') > 30 from jcp_promotions_b p ATTRIBUTES is of type XML Thank you Panneer > Date: Thu, 9 Jan 2014 21:44:11 -0800 > From: pol...@yahoo.com > To: pgsql-gen