Inconsistent PL error handling

From: Dave Page <dpage(at)pgadmin(dot)org>
To: Pg Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Inconsistent PL error handling
Date: 2013-05-09 21:40:04
Message-ID: CA+OCxoyy_2x6cc4YnTwL+CYGgmedkYgL24J7NK+X+_+Y6w43Tw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Whilst working on a build issue with pl/python, I noticed an
inconsistency in the way the server reacts to attempts to use PLs for
which the interpreter doesn't exist. Not sure how feasible it would be
to fix this, but the Python case doesn't seem ideal:

psql.bin (9.3beta1)
Type "help" for help.

postgres=# CREATE LANGUAGE plperl;
ERROR: could not load library
"/opt/PostgreSQL/9.3/lib/postgresql/plperl.so": libperl.so: cannot
open shared object file: No such file or directory
postgres=# CREATE LANGUAGE plpython3u;
CREATE LANGUAGE
postgres=# CREATE FUNCTION pyversion() RETURNS text AS
$$
import sys
return sys.version
$$ LANGUAGE 'plpython3u';
The connection to the server was lost. Attempting reset: Failed.
!>

The server was compiled with both Perl and Python support using the
ActiveState packages on 64 bit Linux on the build machine, but the
runtime machine had neither installed (as would often be the case for
installer packages).

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

--
Sent via pgsql-bugs mailing list (pgsql-bugs(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2013-05-09 23:19:20 Re: BUG #8143: Backend segmentation fault in pg_trgm
Previous Message jroller 2013-05-09 21:28:41 BUG #8143: Backend segmentation fault in pg_trgm