Re: [GENERAL] segfault with plproxy

2011-12-20 Thread Filip Rembiałkowski
W dniu 20 grudnia 2011 15:36 użytkownik Marko Kreen napisał: >> Is schema a part of function signature? > > Yes. Thanks again, that explains everything. In the meantime, depesz has a solution basing on application_name, not on username+schema as I tried. http://www.depesz.com/index.php/2011/1

Re: [GENERAL] segfault with plproxy

2011-12-20 Thread Marko Kreen
On Mon, Dec 19, 2011 at 01:05:20PM +0100, Filip Rembiałkowski wrote: > W dniu 19 grudnia 2011 10:39 użytkownik Marko Kreen > napisał: > > On Sat, Dec 17, 2011 at 10:25:40PM +0100, Filip Rembiałkowski wrote: > >> Following scrip causes segmentation fault. Any ideas why / how to diagnose? > > > >>

Re: [GENERAL] segfault with plproxy

2011-12-19 Thread Filip Rembiałkowski
W dniu 19 grudnia 2011 10:39 użytkownik Marko Kreen napisał: > It seems you are making plproxy call public.list_users() recursively. > Postgres probably OOM-s somewhere then. I have log_statement='all' and the function is called only once: 2011-12-19 13:15:11 CET 20416 [local] testdb filip LOG:

Re: [GENERAL] segfault with plproxy

2011-12-19 Thread Filip Rembiałkowski
W dniu 19 grudnia 2011 10:39 użytkownik Marko Kreen napisał: > On Sat, Dec 17, 2011 at 10:25:40PM +0100, Filip Rembiałkowski wrote: >> Following scrip causes segmentation fault. Any ideas why / how to diagnose? > >> create table part0.users( check(id%2=0) ) inherits (public.users); >> create table

Re: [GENERAL] segfault with plproxy

2011-12-19 Thread Marko Kreen
On Sat, Dec 17, 2011 at 10:25:40PM +0100, Filip Rembiałkowski wrote: > Following scrip causes segmentation fault. Any ideas why / how to diagnose? > create table part0.users( check(id%2=0) ) inherits (public.users); > create table part1.users( check(id%2=1) ) inherits (public.users); > create or r

[GENERAL] segfault with plproxy

2011-12-17 Thread Filip Rembiałkowski
Hello, I have a problem with PL/Proxy (sorry for not posting to plproxy-users, but I have some problem subscribing there). I try to use it to achieve "single node paralellism" - as MattK nicely put it on http://dba.stackexchange.com/questions/9097/single-node-parallelism-with-pl-proxy My setup