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

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

From

Athanasios Kostopoulos

Date:

02 September 2013, 15:49:51

Dear List,

I have encountered a problem that leaves me stumped. I want to install PostGIS and PL/Python on a postgres 9.2 box. I use the apt repositories provided by postgres. After installing from the repos (all binary - no source components involved) I get the following:

postgres@imports2:/tank$ psql

psql (9.2.4)

Type "help" for help.

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.

Amtsgericht Charlottenburg HRB 111815 B | USt.Id.Nr: DE 260731582
Geschäftsführer: Veit Mürz, Fabian Ströhle

Diese Nachricht (inklusive aller Anhänge) ist vertraulich. Sie darf ausschließlich durch den vorgesehenen Empfänger und Adressaten gelesen, kopiert oder genutzt werden. Sollten Sie diese Nachricht versehentlich erhalten haben, bitten wir, den Absender (durch Antwort-E-Mail) hiervon unverzüglich zu informieren und die Nachricht zu löschen. Jede unerlaubte Nutzung oder Weitergabe des Inhalts dieser Nachricht, sei es vollständig oder teilweise, ist unzulässig. Bitte beachten Sie, dass E-Mail-Nachrichten an den Absender nicht für fristgebundene Mitteilungen geeignet sind. Fristgebundene Mitteilungen sind daher ausschließlich per Post oder per Telefax zu übersenden.

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

From

Tom Lane

Date:

02 September 2013, 17:41:04

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