BUG #8344: Python PL broken installation

The following bug has been logged on the website:

Bug reference: 8344
Logged by: philip
Email address: lucere(at)gmail(dot)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