Re: [GENERAL] PG94RC1- plv8 functions - problem with input parameter length

2014-12-01 Thread Ilya Ashchepkov
On Fri, 28 Nov 2014 16:56:01 +0100 Misa Simic wrote: > Hi all, Hello, on Debian Sid and all works fine. postgresql-9.4: Installed: 9.4~rc1-1.pgdg+1 from http://apt.postgresql.org/ plv8js from https://code.google.com/p/plv8js/ > > We have found a strange problem with plv8 functions in PG94RC1

Re: [GENERAL] PG94RC1- plv8 functions - problem with input parameter length

2014-12-01 Thread Andres Freund
On 2014-12-01 16:20:54 +0100, Misa Simic wrote: > We have just found that it creates problems on machines with ubuntu 14.10 > (pg94rc1) - we have tried to install 14.10 in different environments > (cloud, xen, virtual box) - and everywhere problems happens... I suggest running postgres under valgr

Re: [GENERAL] PG94RC1- plv8 functions - problem with input parameter length

2014-12-01 Thread Adrian Klaver
On 12/01/2014 07:20 AM, Misa Simic wrote: -- Adrian Klaver adrian.kla...@aklaver.com Thanks Adrian, Not sure any more where problem could be We have just found that it creates problems on machines with ubuntu 14.10 (pg94rc1) - we have tried to install 14.10 in different e

Re: [GENERAL] PG94RC1- plv8 functions - problem with input parameter length

2014-12-01 Thread Adrian Klaver
On 12/01/2014 07:20 AM, Misa Simic wrote: Thanks Adrian, Not sure any more where problem could be Best guess, interaction of plV8 with system libV8 libraries and some change in 9.4rc1. Not very specific I know. plv8 is not part of the core software for Postgres, so to make progress

Re: [GENERAL] PG94RC1- plv8 functions - problem with input parameter length

2014-12-01 Thread Misa Simic
On Friday, November 28, 2014, Adrian Klaver wrote: > On 11/28/2014 12:18 PM, Misa Simic wrote: > >> >> >> On Friday, November 28, 2014, Adrian Klaver > > wrote: >> >> On 11/28/2014 07:56 AM, Misa Simic wrote: >> >> Hi all, >> >> We have found

Re: [GENERAL] PG94RC1- plv8 functions - problem with input parameter length

2014-11-28 Thread Adrian Klaver
On 11/28/2014 12:18 PM, Misa Simic wrote: On Friday, November 28, 2014, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: On 11/28/2014 07:56 AM, Misa Simic wrote: Hi all, We have found a strange problem with plv8 functions in PG94RC1 PG 9.3 works fine.

Re: [GENERAL] PG94RC1- plv8 functions - problem with input parameter length

2014-11-28 Thread Misa Simic
On Friday, November 28, 2014, Adrian Klaver wrote: > On 11/28/2014 07:56 AM, Misa Simic wrote: > >> Hi all, >> >> We have found a strange problem with plv8 functions in PG94RC1 >> >> PG 9.3 works fine. >> >> in PG94RC1 in plv8 functions regardless what function does i.e.nothing >> >> CREATE OR RE

Re: [GENERAL] PG94RC1- plv8 functions - problem with input parameter length

2014-11-28 Thread Adrian Klaver
On 11/28/2014 08:05 AM, Misa Simic wrote: Update: all works fine and with: PostgreSQL 9.4beta1 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu 4.8.2-19ubuntu1) 4.8.2, 64-bit Installed 9.4rc1 and tried with a plpgsql function and it worked with parameters >= 200, so it seems plV8 specif

Re: [GENERAL] PG94RC1- plv8 functions - problem with input parameter length

2014-11-28 Thread Adrian Klaver
On 11/28/2014 07:56 AM, Misa Simic wrote: Hi all, We have found a strange problem with plv8 functions in PG94RC1 PG 9.3 works fine. in PG94RC1 in plv8 functions regardless what function does i.e.nothing CREATE OR REPLACE FUNCTION test.test_text_length_plv8(in_param1 text) RETURNS text AS $BOD

Re: [GENERAL] PG94RC1- plv8 functions - problem with input parameter length

2014-11-28 Thread Misa Simic
2014-11-28 16:56 GMT+01:00 Misa Simic : > Hi all, > > We have found a strange problem with plv8 functions in PG94RC1 > > PG 9.3 works fine. > > in PG94RC1 in plv8 functions regardless what function does i.e.nothing > > CREATE OR REPLACE FUNCTION test.test_text_length_plv8(in_param1 text) > RETURNS