Create language syntax is not proper in pg_dumpall and not working using pg_upgrade

From: tushar <tushar(dot)ahuja(at)enterprisedb(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Create language syntax is not proper in pg_dumpall and not working using pg_upgrade
Date: 2017-07-25 11:09:39
Message-ID: b95aabd0-4e48-70fd-a510-4edde3d06d09@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

v9.6

postgres=# CREATE LANGUAGE alt_lang1 HANDLER plpgsql_call_handler;
CREATE LANGUAGE
postgres=# \q

v10 , run pg_upgrade - failing with this error -

pg_restore: creating pg_largeobject_metadata "pg_largeobject_metadata"
pg_restore: creating COMMENT "postgres"
pg_restore: creating SCHEMA "public"
pg_restore: creating COMMENT "SCHEMA "public""
pg_restore: creating PROCEDURAL LANGUAGE "alt_lang1"
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 560; 2612 16384
PROCEDURAL LANGUAGE alt_lang1 edb
pg_restore: [archiver (db)] could not execute query: ERROR: unsupported
language "alt_lang1"
HINT: The supported languages are listed in the pg_pltemplate system
catalog.
Command was: CREATE OR REPLACE PROCEDURAL LANGUAGE "alt_lang1";

take the cluster dump using pg_dumpall
"
--
-- Name: alt_lang1; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: edb
--

CREATE OR REPLACE PROCEDURAL LANGUAGE alt_lang1;

ALTER PROCEDURAL LANGUAGE alt_lang1 OWNER TO edb;
"

Handler part is missing and due to that it is throwing an error ,if we
try to execute on psql terminal.

--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tomas Vondra 2017-07-25 11:33:28 Re: VACUUM and ANALYZE disagreeing on what reltuples means
Previous Message Amit Khandekar 2017-07-25 10:24:03 Re: UPDATE of partition key