Thread: Problems with acessing xml functions on other database

Problems with acessing xml functions on other database

From
"x asasaxax"
Date:
Hi everyone,

   I had the folowing problem: when i try to execute a xml_string function on a database 'a' it works, but when i try this in database 'b' it doesen´t works. Did anyone knows what its going on? Is that some kind of permission?

Thanks a lot

Re: Problems with acessing xml functions on other database

From
Richard Huxton
Date:
x asasaxax wrote:
> Hi everyone,
>
>    I had the folowing problem: when i try to execute a xml_string function
> on a database 'a' it works, but when i try this in database 'b' it doesen´t
> works. Did anyone knows what its going on? Is that some kind of permission?

No-one can tell, you didn't provide the error message.

The first thing I'd do is find out where "xml_string" came from - I'm
not aware of any built-in function called that.

--
   Richard Huxton
   Archonet Ltd

Re: Problems with acessing xml functions on other database

From
"Nikolay Samokhvalov"
Date:
On Dec 9, 2007 10:34 PM, x asasaxax <xanaruto@gmail.com> wrote:
> Hi everyone,
>
>    I had the folowing problem: when i try to execute a xml_string function
> on a database 'a' it works, but when i try this in database 'b' it doesen´t
> works. Did anyone knows what its going on? Is that some kind of permission?

Apparently, there is contrib/xml2 installed in database 'a'. Use
contrib/xml2's installation SQL script to install this module in
database 'b'.

--
Nikolay Samokhvalov  <nikolay@samokhvalov.com>
http://nikolay.samokhvalov.com

Postgresmen http://postgresmen.ru
OpenWebTechnologies http://openwebtech.ru