postgresql-plruby
postgresql-plruby copied to clipboard
Doesn't work with Postgres 9.1.2
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='/<redacted>/.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='/<redacted>/.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='/<redacted>/.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='/<redacted>/.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='/<redacted>/.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='/<redacted>/.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