diff options
| author | Bruce Momjian <bruce@momjian.us> | 2002-10-18 18:41:22 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2002-10-18 18:41:22 +0000 |
| commit | aa4c702eac936964649f905741b4a99f4b489200 (patch) | |
| tree | 517d3c28aa3d28eb95b19c8676c940b5cefe2031 /contrib/xml/pgxml_dom.source | |
| parent | fb9bc342fffc157d6ca4b635aeeaccb3c1370b91 (diff) | |
| download | postgresql-aa4c702eac936964649f905741b4a99f4b489200.tar.gz postgresql-aa4c702eac936964649f905741b4a99f4b489200.zip | |
Update /contrib for "autocommit TO 'on'".
Create objects in public schema.
Make spacing/capitalization consistent.
Remove transaction block use for object creation.
Remove unneeded function GRANTs.
Diffstat (limited to 'contrib/xml/pgxml_dom.source')
| -rw-r--r-- | contrib/xml/pgxml_dom.source | 17 |
1 files changed, 13 insertions, 4 deletions
diff --git a/contrib/xml/pgxml_dom.source b/contrib/xml/pgxml_dom.source index a8582398b1e..d5272d742e0 100644 --- a/contrib/xml/pgxml_dom.source +++ b/contrib/xml/pgxml_dom.source @@ -1,7 +1,16 @@ --SQL for XML parser -CREATE FUNCTION pgxml_parse(text) RETURNS bool - AS '_OBJWD_/pgxml_dom_DLSUFFIX_' LANGUAGE 'c' WITH (isStrict); +-- Adjust this setting to control where the objects get created. +SET search_path = public; -CREATE FUNCTION pgxml_xpath(text,text,text,text) RETURNS text - AS '_OBJWD_/pgxml_dom_DLSUFFIX_' LANGUAGE 'c' WITH (isStrict);
\ No newline at end of file +SET autocommit TO 'on'; + +CREATE OR REPLACE FUNCTION pgxml_parse(text) +RETURNS bool +AS '_OBJWD_/pgxml_dom_DLSUFFIX_' +LANGUAGE 'c' WITH (isStrict); + +CREATE OR REPLACE FUNCTION pgxml_xpath(text,text,text,text) +RETURNS text +AS '_OBJWD_/pgxml_dom_DLSUFFIX_' +LANGUAGE 'c' WITH (isStrict); |