Re: extension built-in but now showing in dx/dx+

Athanasios Kostopoulos <athanasios(dot)kostopoulos(at)classmarkets(dot)com> writes:
> postgres=# \dx
> List of installed extensions
> Name | Version | Schema | Description
> ---------+---------+------------+------------------------------
> plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
> (1 row)

> postgres=# CREATE EXTENSION plpythonu;
> ERROR: language "plpythonu" already exists

> I cannot see the extension(s) but when I am trying to create them I get a
> message that they already exist?!? What am I missing? Thanks in advance for
> any replies.

The message is about the language, not the extension. Apparently you've
got an old "unpackaged" version of plpythonu. \dL would show it.

You could try "create extension plpythonu from unpackaged". But it'd
probably be cleaner if you can drop the old language altogether (ie, you
don't have or don't care about any functions in this language).

regards, tom lane