Re: extension built-in but now showing in dx/dx+ - Mailing list pgsql-novice

From Tom Lane
Subject Re: extension built-in but now showing in dx/dx+
Date
Msg-id 15143.1378132856@sss.pgh.pa.us
Whole thread Raw
In response to extension built-in but now showing in dx/dx+  (Athanasios Kostopoulos <athanasios.kostopoulos@classmarkets.com>)
List pgsql-novice
Athanasios Kostopoulos <athanasios.kostopoulos@classmarkets.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


pgsql-novice by date:

Previous
From: Athanasios Kostopoulos
Date:
Subject: extension built-in but now showing in dx/dx+
Next
From: Jeff Davis
Date:
Subject: Re: Bit count