knu/postgresql-plruby — Issue #8: Doesn't work with Postgres 9.1.2
Author: dfrankow
Created: 2012-01-30 16:35:18+00:00
State: open

Full output of "make test" is below. However, one issue is:

ERROR: syntax error at or near "lancompiler"
LINE 3: lancompiler 'PL/Ruby';

If I Google for lancompiler, I get http://www.postgresql.org/docs/7.1/static/sql-createlanguage.html. If I look instead at http://www.postgresql.org/docs/9.1/static/sql-createlanguage.html, lancompiler is gone.

This code likely needs to be updated for newer Postgres versions.

```
dan-pro:~/Downloads/knu-postgresql-plruby-1f54eea $ make test
(cd test/conv_bitstring ; RUBY='//.rvm/rubies/ruby-1.9.3-p0/bin/ruby' sh ./runtest 91 )
**** Destroy old database plruby_test ****
dropdb: database removal failed: ERROR: database "plruby_test" does not exist
**** Create test database plruby_test ****
**** Create procedural language plruby ****
b.rb:3: Use RbConfig instead of obsolete and deprecated Config.
ERROR: syntax error at or near "lancompiler"
LINE 3: lancompiler 'PL/Ruby';
^
**** Running test queries ****
Tests failed - look at diffs between
test.expected.91 and test.out
(cd test/conv_geometry ; RUBY='//.rvm/rubies/ruby-1.9.3-p0/bin/ruby' sh ./runtest 91 )
**** Destroy old database plruby_test ****
**** Create test database plruby_test ****
**** Create procedural language plruby ****
b.rb:3: Use RbConfig instead of obsolete and deprecated Config.
ERROR: syntax error at or near "lancompiler"
LINE 3: lancompiler 'PL/Ruby';
^
**** Running test queries ****
Tests failed - look at diffs between
test.expected.91 and test.out
(cd test/conv_network ; RUBY='//.rvm/rubies/ruby-1.9.3-p0/bin/ruby' sh ./runtest 91 )
**** Destroy old database plruby_test ****
**** Create test database plruby_test ****
**** Create procedural language plruby ****
b.rb:3: Use RbConfig instead of obsolete and deprecated Config.
ERROR: syntax error at or near "lancompiler"
LINE 3: lancompiler 'PL/Ruby';
^
**** Running test queries ****
Tests failed - look at diffs between
test.expected.91 and test.out
(cd test/plp ; RUBY='//.rvm/rubies/ruby-1.9.3-p0/bin/ruby' sh ./runtest 91 )
**** Destroy old database plruby_test ****
**** Create test database plruby_test ****
**** Create procedural language plruby ****
b.rb:3: Use RbConfig instead of obsolete and deprecated Config.
ERROR: syntax error at or near "lancompiler"
LINE 3: lancompiler 'PL/Ruby';
^
**** Create tables, functions and triggers ****
ERROR: language "plruby" does not exist
ERROR: function tg_room_au() does not exist
ERROR: language "plruby" does not exist
ERROR: function tg_room_ad() does not exist
ERROR: language "plruby" does not exist
ERROR: function tg_wslot_biu() does not exist
ERROR: language "plruby" does not exist
ERROR: function tg_pfield_au() does not exist
ERROR: language "plruby" does not exist
ERROR: function tg_pfield_ad() does not exist
ERROR: language "plruby" does not exist
ERROR: function tg_pslot_biu() does not exist
ERROR: language "plruby" does not exist
ERROR: function tg_system_au() does not exist
ERROR: language "plruby" does not exist
ERROR: function tg_iface_biu() does not exist
ERROR: language "plruby" does not exist
ERROR: function tg_hub_a() does not exist
ERROR: language "plruby" does not exist
ERROR: function tg_hslot_biu() does not exist
ERROR: language "plruby" does not exist
ERROR: function tg_hslot_bd() does not exist
ERROR: language "plruby" does not exist
ERROR: function tg_chkslotname() does not exist
ERROR: function tg_chkslotname() does not exist
ERROR: function tg_chkslotname() does not exist
ERROR: function tg_chkslotname() does not exist
ERROR: function tg_chkslotname() does not exist
ERROR: language "plruby" does not exist
ERROR: function tg_chkslotlink() does not exist
ERROR: function tg_chkslotlink() does not exist
ERROR: function tg_chkslotlink() does not exist
ERROR: function tg_chkslotlink() does not exist
ERROR: function tg_chkslotlink() does not exist
ERROR: language "plruby" does not exist
ERROR: function tg_chkbacklink() does not exist
ERROR: function tg_chkbacklink() does not exist
ERROR: function tg_chkbacklink() does not exist
ERROR: language "plruby" does not exist
ERROR: function tg_pslot_bu() does not exist
ERROR: language "plruby" does not exist
ERROR: function tg_wslot_bu() does not exist
ERROR: language "plruby" does not exist
ERROR: function tg_pline_bu() does not exist
ERROR: language "plruby" does not exist
ERROR: function tg_iface_bu() does not exist
ERROR: language "plruby" does not exist
ERROR: function tg_hslot_bu() does not exist
ERROR: language "plruby" does not exist
ERROR: function tg_phone_bu() does not exist
ERROR: language "plruby" does not exist
ERROR: function tg_backlink_a() does not exist
ERROR: function tg_backlink_a() does not exist
ERROR: function tg_backlink_a() does not exist
ERROR: language "plruby" does not exist
ERROR: function tg_slotlink_a() does not exist
ERROR: function tg_slotlink_a() does not exist
ERROR: function tg_slotlink_a() does not exist
ERROR: function tg_slotlink_a() does not exist
ERROR: function tg_slotlink_a() does not exist
ERROR: language "plruby" does not exist
ERROR: language "plruby" does not exist
ERROR: language "plruby" does not exist
ERROR: function pslot_backlink_view(character varying) does not exist
LINE 2: pslot_backlink_view(PF.slotname) as backside,
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
**** Running test queries ****
Tests failed - look at diffs between
test.expected.91 and test.out
(cd test/plt ; RUBY='//.rvm/rubies/ruby-1.9.3-p0/bin/ruby' sh ./runtest 91 )
**** Destroy old database plruby_test ****
**** Create test database plruby_test ****
**** Create procedural language plruby ****
b.rb:3: Use RbConfig instead of obsolete and deprecated Config.
ERROR: syntax error at or near "lancompiler"
LINE 3: lancompiler 'PL/Ruby';
^
**** Create tables, functions and triggers ****
ERROR: language "plruby" does not exist
ERROR: language "plruby" does not exist
ERROR: function trig_pkey1_before() does not exist
ERROR: language "plruby" does not exist
ERROR: function trig_pkey2_before() does not exist
ERROR: language "plruby" does not exist
ERROR: function trig_pkey2_after() does not exist
ERROR: language "plruby" does not exist
ERROR: function check_primkey() does not exist
ERROR: function check_primkey() does not exist
ERROR: language "plruby" does not exist
ERROR: language "plruby" does not exist
ERROR: language "plruby" does not exist
ERROR: function ruby_int4_accum(integer[], integer) does not exist
ERROR: function ruby_int4add(integer, integer) does not exist
ERROR: language "plruby" does not exist
ERROR: function ruby_int4lt(integer, integer) does not exist
**** Running test queries ****
Tests failed - look at diffs between
test.expected.91 and test.out
(cd test/range ; RUBY='//.rvm/rubies/ruby-1.9.3-p0/bin/ruby' sh ./runtest 91 )
**** Destroy old database plruby_test ****
**** Create test database plruby_test ****
**** Create procedural language plruby ****
b.rb:3: Use RbConfig instead of obsolete and deprecated Config.
ERROR: syntax error at or near "lancompiler"
LINE 3: lancompiler 'PL/Ruby';
^
**** Running test queries ****
Tests failed - look at diffs between
test.expected.91 and test.out
```