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
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 |