42
42
'check next sequence value';
44
44
# create stored procedures
45
is_program_out 'postgres', 'createlang plpgsql test', 0, '', 'createlang plpgsql test';
46
is_program_out 'postgres', 'createlang plpgsql test', 0, '', 'createlang plpgsql test';
46
51
is_program_out 'nobody', 'psql test -c "CREATE FUNCTION inc2(integer) RETURNS integer LANGUAGE plpgsql AS \'BEGIN RETURN \$1 + 2; END;\';"',
47
52
0, "CREATE FUNCTION\n", 'create function inc2';
48
53
is_program_out 'postgres', "psql -c \"update pg_proc set probin = '/usr/lib/postgresql/$MAJORS[0]/lib/plpgsql.so' where proname = 'plpgsql_call_handler';\" test",