BUG #8344: Python PL broken installation

The following bug has been logged on the website:

Bug reference:      8344
Logged by:          philip
Email address:      lucere@gmail.com
PostgreSQL version: 9.2.4
Operating system:   OSX 10.8
Description:

Executing,
CREATE EXTENSION plpythonu;
********** Error **********
ERROR: could not open extension control file
"/Library/PostgreSQL/9.2/share/postgresql/extension/plpythonu.control": No
such file or directory
SQL state: 58P01


Executing,
CREATE EXTENSION plpython2u;
********** Error **********
ERROR: could not open extension control file
"/Library/PostgreSQL/9.2/share/postgresql/extension/plpython2u.control": No
such file or directory
SQL state: 58P01


Executing,
CREATE EXTENSION plpython3u;
********** Error **********
ERROR: could not load library
"/Library/PostgreSQL/9.2/lib/postgresql/plpython3.so":
dlopen(/Library/PostgreSQL/9.2/lib/postgresql/plpython3.so, 10): Library not
loaded: /Library/Frameworks/Python.framework/Versions/3.2/Python
  Referenced from: /Library/PostgreSQL/9.2/lib/postgresql/plpython3.so
  Reason: image not found
SQL state: 58P01


But, /Library/PostgreSQL/9.2/lib/postgresql/plpython3.so _does_ exist


Furthermore,
postgres=# SELECT * FROM pg_pltemplate;
  tmplname  | tmpltrusted | tmpldbacreate |      tmplhandler       |
tmplinline        |    tmplvalidator    |    tmpllibrary    | tmplacl

------------+-------------+---------------+------------------------+--------------------------+---------------------+-------------------+---------
 plpgsql    | t           | t             | plpgsql_call_handler   |
plpgsql_inline_handler   | plpgsql_validator   | $libdir/plpgsql   |
 pltcl      | t           | t             | pltcl_call_handler     |
                 |                     | $libdir/pltcl     |
 pltclu     | f           | f             | pltclu_call_handler    |
                 |                     | $libdir/pltcl     |
 plperl     | t           | t             | plperl_call_handler    |
plperl_inline_handler    | plperl_validator    | $libdir/plperl    |
 plperlu    | f           | f             | plperlu_call_handler   |
plperlu_inline_handler   | plperlu_validator   | $libdir/plperl    |
 plpythonu  | f           | f             | plpython_call_handler  |
plpython_inline_handler  | plpython_validator  | $libdir/plpython2 |
 plpython2u | f           | f             | plpython2_call_handler |
plpython2_inline_handler | plpython2_validator | $libdir/plpython2 |
 plpython3u | f           | f             | plpython3_call_handler |
plpython3_inline_handler | plpython3_validator | $libdir/plpython3 |
(8 rows)


And,
postgres=# SELECT * FROM pg_available_extensions;
        name        | default_version | installed_version |
             comment

--------------------+-----------------+-------------------+----------------------------------------------------------------------
 adminpack          | 1.0             | 1.0               | administrative
functions for PostgreSQL
 autoinc            | 1.0             |                   | functions for
autoincrementing fields
 btree_gin          | 1.0             |                   | support for
indexing common datatypes in GIN
 btree_gist         | 1.0             |                   | support for
indexing common datatypes in GiST
 chkpass            | 1.0             |                   | data type for
auto-encrypted passwords
 citext             | 1.0             |                   | data type for
case-insensitive character strings
 cube               | 1.0             |                   | data type for
multidimensional cubes
 dblink             | 1.0             |                   | connect to other
PostgreSQL databases from within a database
 dict_int           | 1.0             |                   | text search
dictionary template for integers
 dict_xsyn          | 1.0             |                   | text search
dictionary template for extended synonym processing
 earthdistance      | 1.0             |                   | calculate
great-circle distances on the surface of the Earth
 file_fdw           | 1.0             |                   | foreign-data
wrapper for flat file access
 fuzzystrmatch      | 1.0             |                   | determine
similarities and distance between strings
 hstore             | 1.1             |                   | data type for
storing sets of (key, value) pairs
 insert_username    | 1.0             |                   | functions for
tracking who changed a table
 intagg             | 1.0             |                   | integer
aggregator and enumerator (obsolete)
 intarray           | 1.0             |                   | functions,
operators, and index support for 1-D arrays of integers
 isn                | 1.0             |                   | data types for
international product numbering standards
 lo                 | 1.0             |                   | Large Object
maintenance
 ltree              | 1.0             |                   | data type for
hierarchical tree-like structures
 moddatetime        | 1.0             |                   | functions for
tracking last modification time
 pageinspect        | 1.0             |                   | inspect the
contents of database pages at a low level
 pg_buffercache     | 1.0             |                   | examine the
shared buffer cache
 pg_freespacemap    | 1.0             |                   | examine the free
space map (FSM)
 pg_stat_statements | 1.1             |                   | track execution
statistics of all SQL statements executed
 pg_trgm            | 1.0             |                   | text similarity
measurement and index searching based on trigrams
 pgcrypto           | 1.0             |                   | cryptographic
functions
 pgrowlocks         | 1.0             |                   | show row-level
locking information
 pgstattuple        | 1.0             |                   | show tuple-level
statistics
 pldbgapi           | 1.0             |                   | server-side
support for debugging PL/pgSQL functions
 plperl             | 1.0             |                   | PL/Perl
procedural language
 plperlu            | 1.0             |                   | PL/PerlU
untrusted procedural language
 plpgsql            | 1.0             | 1.0               | PL/pgSQL
procedural language
 plpython3u         | 1.0             |                   | PL/Python3U
untrusted procedural language
 pltcl              | 1.0             |                   | PL/Tcl
procedural language
 pltclu             | 1.0             |                   | PL/TclU
untrusted procedural language
 refint             | 1.0             |                   | functions for
implementing referential integrity (obsolete)
 seg                | 1.0             |                   | data type for
representing line segments or floating-point intervals
 sslinfo            | 1.0             |                   | information
about SSL certificates
 tablefunc          | 1.0             |                   | functions that
manipulate whole tables, including crosstab
 tcn                | 1.0             |                   | Triggered change
notifications
 test_parser        | 1.0             |                   | example of a
custom parser for full-text search
 timetravel         | 1.0             |                   | functions for
implementing time travel
 tsearch2           | 1.0             |                   | compatibility
package for pre-8.3 text search functions
 unaccent           | 1.0             |                   | text search
dictionary that removes accents
 uuid-ossp          | 1.0             |                   | generate
universally unique identifiers (UUIDs)
 xml2               | 1.0             |                   | XPath querying
and XSLT
(47 rows)


And,
postgres=# SELECT * FROM pg_language;
 lanname  | lanowner | lanispl | lanpltrusted | lanplcallfoid | laninline |
lanvalidator | lanacl
----------+----------+---------+--------------+---------------+-----------+--------------+--------
 internal |       10 | f       | f            |             0 |         0 |
       2246 |
 c        |       10 | f       | f            |             0 |         0 |
       2247 |
 sql      |       10 | f       | t            |             0 |         0 |
       2248 |
 plpgsql  |       10 | t       | t            |         11996 |     11997 |
      11998 |
(4 rows)


Kind regards