Summary: | dev-db/postgresql-8.1.4 'xml' USE flag does not add xml support | ||
---|---|---|---|
Product: | Gentoo Linux | Reporter: | Dennis <aiwa_azca> |
Component: | New packages | Assignee: | PgSQL Bugs <pgsql-bugs> |
Status: | VERIFIED INVALID | ||
Severity: | normal | CC: | esigra |
Priority: | High | ||
Version: | 2006.1 | ||
Hardware: | All | ||
OS: | Other | ||
Whiteboard: | |||
Package list: | Runtime testing required: | --- |
Description
Dennis
2006-11-09 23:14:33 UTC
I got it to work by emerging the new ebuild of PostgreSQL 8.1.5 and then running this script from PgAdmin III --SQL for XML parser CREATE OR REPLACE FUNCTION xml_valid(text) RETURNS bool AS '/usr/lib/postgresql/pgxml.so' LANGUAGE 'c' STRICT IMMUTABLE; CREATE OR REPLACE FUNCTION xml_encode_special_chars(text) RETURNS text AS '/usr/lib/postgresql/pgxml.so' LANGUAGE 'c' STRICT IMMUTABLE; CREATE OR REPLACE FUNCTION xpath_string(text,text) RETURNS text AS '/usr/lib/postgresql/pgxml.so' LANGUAGE 'c' STRICT IMMUTABLE; CREATE OR REPLACE FUNCTION xpath_nodeset(text,text,text,text) RETURNS text AS '/usr/lib/postgresql/pgxml.so' LANGUAGE 'c' STRICT IMMUTABLE; CREATE OR REPLACE FUNCTION xpath_number(text,text) RETURNS float4 AS '/usr/lib/postgresql/pgxml.so' LANGUAGE 'c' STRICT IMMUTABLE; CREATE OR REPLACE FUNCTION xpath_bool(text,text) RETURNS boolean AS '/usr/lib/postgresql/pgxml.so' LANGUAGE 'c' STRICT IMMUTABLE; -- List function CREATE OR REPLACE FUNCTION xpath_list(text,text,text) RETURNS text AS '/usr/lib/postgresql/pgxml.so' LANGUAGE 'c' STRICT IMMUTABLE; CREATE OR REPLACE FUNCTION xpath_list(text,text) RETURNS text AS 'SELECT xpath_list($1,$2,'','')' language 'SQL' STRICT IMMUTABLE; -- Wrapper functions for nodeset where no tags needed CREATE OR REPLACE FUNCTION xpath_nodeset(text,text) RETURNS text AS 'SELECT xpath_nodeset($1,$2,'''','''')' language 'SQL' STRICT IMMUTABLE; CREATE OR REPLACE FUNCTION xpath_nodeset(text,text,text) RETURNS text AS 'SELECT xpath_nodeset($1,$2,'''',$3)' language 'SQL' STRICT IMMUTABLE; -- Table function CREATE OR REPLACE FUNCTION xpath_table(text,text,text,text,text) RETURNS setof record AS '/usr/lib/postgresql/pgxml.so' LANGUAGE 'c' STRICT STABLE; -- XSLT functions -- Delete from here to the end of the file if you are not compiling with -- XSLT support. CREATE OR REPLACE FUNCTION xslt_process(text,text,text) RETURNS text AS '/usr/lib/postgresql/pgxml.so' LANGUAGE 'c' STRICT VOLATILE; -- the function checks for the correct argument count CREATE OR REPLACE FUNCTION xslt_process(text,text) RETURNS text AS '/usr/lib/postgresql/pgxml.so' LANGUAGE 'c' STRICT IMMUTABLE; 'xml' USE flag only builds the contrib module. Enabling support in the databases is the DBA's responsibility. |