search

kokizzu / plv8js

Automatically exported from code.google.com/p/plv8js
Other
0 stars 0 forks source link

plcoffee on Pg9.2 #38

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
Hi,

We can't get plcoffee to work...

make ENABLE_COFFEE=1 install

passed well, without any problems...

make ENABLE_COFFEE=1 installcheck

passed - but noticed there are no test for plcoffee

create new DB,

CREATE EXTENSION (both, plv8 and plcoffee) passed well...

CREATE LANGUAGE - a bit unusual - for both says language already exists... 

plv8 functions - works fine (as DO)

CREATE FUNCTION in plcoffee breaks - without an error - just connection 
breaks...

The same happens and for DO statemebts:

DO LANGUAGE plcoffee
$$

$$

even it is empty... or not empty and no syntax error... just breaks 
connection...

The same happens in PgAdmin from client machine.. as on psql on the server...

Server: Ubuntu 1204
Pg: 9.2

plv8js - latest snapshot...

Any advice?

Thanks,

Misa

Original issue reported on code.google.com by misa.si...@gmail.com on 25 Sep 2012 at 12:30

GoogleCodeExporter commented 9 years ago 
[deleted comment]
GoogleCodeExporter commented 9 years ago 
It works fine for me in Mac.  You don't need CREATE LANGUAGE as CREATE 
EXTENSION does it.  But I have no idea why plcoffee doesn't work while plv8 
does.  How many bytes does your plv8.so have?

Original comment by umi.tan...@gmail.com on 25 Sep 2012 at 7:21

GoogleCodeExporter commented 9 years ago 
Hi,

size of plv8.so is 185969

we are building Postgres from source, but changing in  
/src/include/pg_config_manual.h:

NAMEDATALEN 256
INDEX_MAX_KEYS 128

./configure --with-perl --with-python -- with-openssl --with-ossp-uuid 
--with-libxml --with-libxslt

Another difference is, when we build v8, we copy libv8.so to /usr/lib but also 
copy whole x64.release to /usr/local/v8, and then /usr/local/v8 we add to PATH

We will give another try with git ( we have used latest snapshot) in that we 
have had problem plcoffee--0.9.0.sql - file has been named plcoffee--0.9.sql 
and we have changed that part in Makefile...

Thanks,

Misa

Original comment by misa.si...@gmail.com on 25 Sep 2012 at 9:54

GoogleCodeExporter commented 9 years ago 
Hi,

using source from git - everything works fine... 

Is there possibility that latest snapshot is not OK? (We have tried several 
times on different VMs, without success...)

Thanks,

Misa

Original comment by misa.si...@gmail.com on 25 Sep 2012 at 3:24

GoogleCodeExporter commented 9 years ago 
Hm, I don't see the issue here with the latest snapshot downloaded into my mac. 
 I don't think there's so much difference between the snapshot and the current 
master, except the version number was bad (.control file states 0.9 while 
Makefile assumed 0.9.0).

Original comment by umi.tan...@gmail.com on 25 Sep 2012 at 4:27

GoogleCodeExporter commented 9 years ago 
OK, no probs...

This issue can be closed - git option works fine and should be better anyway...

Many thanks,

Misa

Original comment by misa.si...@gmail.com on 25 Sep 2012 at 4:42

GoogleCodeExporter commented 9 years ago

Original comment by umi.tan...@gmail.com on 26 Sep 2012 at 5:05