Обсуждение: PG 9.1.1 - availability of xslt_process()
Hi,
I'm using the compiled version of PG 9.1.1 on win32 .
try-ing to call the xslt_process(text,text) (two parameter version)
PG say me it is not available.
In the docs are say that it is available only if compiled with the libxslt lib.
I see that dll is available in the lib folder.
So I guess it should be available.
To verify if it is available I search that function in the list of functions with pg-admin.
But it is not available.Neither the three parameter version of xslt_process() is available.
Perhaps is need to run some script to have it available ?
Thx,
--
-----------------
Andrea Peri
. . . . . . . . .
qwerty àèìòù
-----------------
I'm using the compiled version of PG 9.1.1 on win32 .
try-ing to call the xslt_process(text,text) (two parameter version)
PG say me it is not available.
In the docs are say that it is available only if compiled with the libxslt lib.
I see that dll is available in the lib folder.
So I guess it should be available.
To verify if it is available I search that function in the list of functions with pg-admin.
But it is not available.Neither the three parameter version of xslt_process() is available.
Perhaps is need to run some script to have it available ?
Thx,
--
-----------------
Andrea Peri
. . . . . . . . .
qwerty àèìòù
-----------------
On 10/26/11 11:13 PM, Andrea Peri wrote: > Hi, > > I'm using the compiled version of PG 9.1.1 on win32 . > > try-ing to call the xslt_process(text,text) (two parameter version) > > PG say me it is not available. > > In the docs are say that it is available only if compiled with the > libxslt lib. > I see that dll is available in the lib folder. > So I guess it should be available. > > To verify if it is available I search that function in the list of > functions with pg-admin. > But it is not available.Neither the three parameter version of > xslt_process() is available. > > Perhaps is need to run some script to have it available ? > isn't that part of the deprecated XML2 contributed module? wild guess says you need to install the contrib module with something like... CREATE EXTENSION xml2; but, as a deprecated module, XML2 has been on the 'remove soon' list since 8.4. Instead,, you should use the SQL/XML standard compliant functions built into postgres, -- john r pierce N 37, W 122 santa cruz ca mid-left coast
On Oct 27, 2011, at 11:43 AM, Andrea Peri wrote: > Hi, > > I'm using the compiled version of PG 9.1.1 on win32 . > > try-ing to call the xslt_process(text,text) (two parameter version) > > PG say me it is not available. > > In the docs are say that it is available only if compiled with the libxslt lib. > I see that dll is available in the lib folder. > So I guess it should be available. > > To verify if it is available I search that function in the list of functions with pg-admin. > But it is not available.Neither the three parameter version of xslt_process() is available. > > Perhaps is need to run some script to have it available ? xslt_process function is part of xml2 contrib module. Execute following for xml2 CREATE EXTENSION xml2; Thanks & Regards, Vibhor Kumar EnterpriseDB Corporation The Enterprise PostgreSQL Company Blog: http://vibhork.blogspot.com
Hi Vibor, thx for hint. it resolve. Really great new the extension command ! Best regards, Il 27/10/2011 08:47, Vibhor Kumar ha scritto: > > On Oct 27, 2011, at 11:43 AM, Andrea Peri wrote: > >> Hi, >> >> I'm using the compiled version of PG 9.1.1 on win32 . >> >> try-ing to call the xslt_process(text,text) (two parameter version) >> >> PG say me it is not available. >> >> In the docs are say that it is available only if compiled with the libxslt lib. >> I see that dll is available in the lib folder. >> So I guess it should be available. >> >> To verify if it is available I search that function in the list of functions with pg-admin. >> But it is not available.Neither the three parameter version of xslt_process() is available. >> >> Perhaps is need to run some script to have it available ? > > > xslt_process function is part of xml2 contrib module. Execute following for xml2 > > CREATE EXTENSION xml2; > > Thanks& Regards, > Vibhor Kumar > EnterpriseDB Corporation > The Enterprise PostgreSQL Company > Blog: http://vibhork.blogspot.com > >