Обсуждение: [BUGS] BUG #14583: plpythonu : subprocess not working in function
[BUGS] BUG #14583: plpythonu : subprocess not working in function
От
paulo.nuno.leite@gmail.com
Дата:
The following bug has been logged on the website: Bug reference: 14583 Logged by: Paulo B Email address: paulo.nuno.leite@gmail.com PostgreSQL version: 9.5.6 Operating system: Windows Description: I have the following function that runs a command: CREATE OR REPLACE FUNCTION public.classify_test() RETURNS void AS $BODY$ import os from subprocess import Popen, PIPE import subprocess import os from subprocess import Popen, PIPE echo=Popen(('echo', '123'), shell=True) p = subprocess.Popen(['python.exe', '-u','test.py'], stdin = echo.stdout, universal_newlines = True, shell = True) $BODY$ LANGUAGE plpythonu VOLATILE COST 100; ALTER FUNCTION public.classify_test() OWNER TO postgres; if I run this fuction as select classify_test() it will not run the python script. However, if I run it in the command line it will work. It works as well in SublimeText2 IDE. I have been trying to find what the bug or problem is, but had no success. I am using python2.7, I have psycopg2 installed. Why doesn't postgresql execute the python script? -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
On 8 March 2017 at 17:51, <paulo.nuno.leite@gmail.com> wrote:
The following bug has been logged on the website:
Bug reference: 14583
Logged by: Paulo B
Email address: paulo.nuno.leite@gmail.com
PostgreSQL version: 9.5.6
Operating system: Windows
Description:
I have the following function that runs a command:
CREATE OR REPLACE FUNCTION public.classify_test()
RETURNS void AS
$BODY$
import os
from subprocess import Popen, PIPE
import subprocess
import os
from subprocess import Popen, PIPE
echo=Popen(('echo', '123'), shell=True)
p = subprocess.Popen(['python.exe', '-u','test.py'], stdin = echo.stdout,
universal_newlines = True, shell = True)
$BODY$
LANGUAGE plpythonu VOLATILE
COST 100;
ALTER FUNCTION public.classify_test()
OWNER TO postgres;
if I run this fuction as select classify_test() it will not run the python
script. However, if I run it in the command line it will work. It works as
well in SublimeText2 IDE. I have been trying to find what the bug or problem
is, but had no success. I am using python2.7, I have psycopg2 installed.
Why doesn't postgresql execute the python script?
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
I had the same problem migrating to python3. My python3 code now looks like
$BODY$
import subprocess
plpy.execute('drop server if exists fi_server_{} cascade'.format(id))
try:
subprocess.check_output(['/usr/local/bin/ogr_fdw_info',
'-s', 'fi_server_{}'.format(id),
'-t', 'import.t{0}_{1}'.format(id, worksheet),
'-d', filename,
'-w', str(worksheet)
])
except subprocess.CalledProcessError, e:
if e.returncode == 1:
plpy.execute(e.output)
return None
else:
return e.output
Hope this helps
Kieran