The following bug has been logged on the website: Bug reference: 8344 Logged by: philip Email address: luc...@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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs