Skip to content

ALTER EXTENSION UPDATE does not create sqlj.alias_java_language() #341

Closed

Description

@jcflack

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

  1. added 2 commits that reference this issue on Mar 28, 2021
  2. jcflack commented on Oct 10, 2021

    @jcflack
    ContributorAuthor

    Believed resolved in 1.6.3.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions