Must be Owner of Language plpgsql while Importing

Symptoms

During the import of data to PostgreSQL database the ERROR: “must be owner of language plpgsql” while importing appears.

Cause

The problem occurs due to the inability to execute the command:

CREATE OR REPLACE LANGUAGE plpgsql;

plpgsql - is a loadable procedural language for creating functions, procedures and triggers. You also can use this language for direct execution of code in DO blocks.

Before running the import process our tool create plpgsql language in DB so all objects can be created with plpgsql language.

Solution

The user must have the PostgreSQL super user privilege to register a new language - https://www.postgresql.org/docs/9.0/sql-createlanguage.html

For correct import process please add all necessary privileges for your PostgreSQL user or try register plpgsql manually.

If you have any other questions, please contact us: support@ispirer.com