[GENERAL] pgpool slony slaves only

2010-12-07 Thread Frank Jansen
read and never write. We want just connection pooling and load balacing through pgpool to our 2 slaves. Couldnt find anyone on google using pgpool to access read only his slony slaves, maybe someone has suggestions for me. Regards, Frank Jansen -- Sent via pgsql-general mailing list (pgsql

[GENERAL] Postgres 8.4 Segfault on xpath

2010-03-15 Thread Frank jansen
lost. Kind regards, Frank Jansen The function: feedimport.is_blacklisted(p_external_broker_id,xpath_string(l_xml_item,'/immobilie/verwaltung_techn/objektnr_extern')) -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscrip

Re: [GENERAL] Postgres 8.4 Segfault on xpath

2010-03-15 Thread Frank jansen
Am 15.03.2010 12:56, schrieb Magnus Hagander: On Mon, Mar 15, 2010 at 11:47, Dimitri Fontaine wrote: Frank jansen writes: I tried postgres 8.4.0 and 8.4.2 self compiled with elf compiled contrib directory, tried Debians 8.4 backport package with the 8.4 contrib package and all do

[GENERAL] Move to core xml from contrib/xml2

2010-03-15 Thread Frank jansen
. But i have no clue how to change the database functions so they use the core xml support. I have already uninstalled contrib/xml2, but now i dont know further. I seem to cannot find any information how to use the core xml support in the manuals or anywhere in the net. Thanks in advice, Frank

Re: [GENERAL] Move to core xml from contrib/xml2

2010-03-16 Thread Frank jansen
Am 15.03.2010 22:10, schrieb Bruce Momjian: Frank jansen wrote: Hi, we have encountered huge memory problems (segfault on 8.4.2, out of memory on 8.4.3) with our xml functions when moving from 8.3 to 8.4, as mentioned here: http://archives.postgresql.org/pgsql-general/2010-03/msg00563.php

[GENERAL] Concatenate

2010-03-24 Thread Frank jansen
ke at most one set argument" EXECUTE' ... md5_hash=md5(unnest(xpath(''/foo/bar'',xml_content::xml))::text) || (unnest(xpath(''/foo/bar2'',xml_content::xml))::text) Kind regards, Frank Jansen -- Sent via pgsql-general mailing list

Re: [GENERAL] Concatenate [solved]

2010-03-24 Thread Frank jansen
Am 24.03.2010 14:41, schrieb Merlin Moncure: On Wed, Mar 24, 2010 at 6:22 AM, Frank jansen wrote: Hi, can you help me with this tricky concat i have? I have a function with an execute statement, one line of it doing an md5 hash of some concatenated xml paths with values. I cannot get