Re: [GENERAL] Error when building new db using pg_restore

On 06/22/2017 10:05 AM, Jim Longwill wrote:

>>
>>
> Ok.  Thank you for the input.  I do see the 'Description' of plpgsql
> there.  So, if I can determine the source table(s) of this information
> perhaps I could delete that particular value.    I tried the following
> as per documentation:
>    COMMENT ON EXTENSION plpgsql IS NULL;
> But it did not appear to remove the comment/description.   will
> investigate further..

Probably because languages are installed as extensions now and have an
extension script:

plpgsql--1.0.sql


/* src/pl/plpgsql/src/plpgsql--1.0.sql */

/*
  * Currently, all the interesting stuff is done by CREATE LANGUAGE.
  * Later we will probably "dumb down" that command and put more of the
  * knowledge into this script.
  */

CREATE PROCEDURAL LANGUAGE plpgsql;

COMMENT ON PROCEDURAL LANGUAGE plpgsql IS 'PL/pgSQL procedural language';


> --Jim  :^)


--
Adrian Klaver
adrian.klaver@aklaver.com