Skip to content

Doesn't work with Postgres 9.1.2 #8

@dfrankow

Description

@dfrankow

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions