You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
Repository navigation
ALTER EXTENSION UPDATE does not create sqlj.alias_java_language() #341
1.6.0 introduced the sqlj.alias_java_language function, but it is missing after ALTER EXTENSION UPDATE to 1.6.0 through 1.6.2 from an earlier version.
The addition of a new function also constitutes a new SchemaVariant that should be detected in InstallHelper and handled for update. That was overlooked.
Workaround:
ALTER EXTENSION pljava UPDATE;
CREATE OR REPLACE FUNCTION sqlj.alias_java_language(
alias pg_catalog.varchar,
sandboxed boolean,
orReplace boolean DEFAULT CAST(e'false' AS boolean),
comment pg_catalog.varchar DEFAULT CAST(e'' AS pg_catalog.varchar))
RETURNS pg_catalog.void
LANGUAGE java VOLATILE
AS e'void=org.postgresql.pljava.management.Commands.aliasJavaLanguage(java.lang.String,java.lang.Boolean,java.lang.Boolean,java.lang.String)'
COMMENT ON FUNCTION sqlj.alias_java_language(
alias pg_catalog.varchar,
sandboxed boolean,
orReplace boolean,
comment pg_catalog.varchar)
IS e'Creates a named PostgreSQL {@code LANGUAGE} that refers to PL/Java;
its name may be referred to in the Java security policy to grant selected
permissions to functions created in this "language".'
ALTER EXTENSION pljava ADD FUNCTION sqlj.alias_java_language;
Activity
Install 1.6.0's new sqlj function when updating
Merge pull request #344 from bug/REL1_6_STABLE/issue341
jcflack commentedon Oct 10, 2021
Believed resolved in 1.6.3.