plpython2u not getting any output -> on independent script I get the desired output - Mailing list pgsql-general

From ichBinRene
Subject plpython2u not getting any output -> on independent script I get the desired output
Date
Msg-id CAN_6MJauUdH8pcLbfx=Kwa7RP=E-OuQVigXDqa-VjhERtFWnxQ@mail.gmail.com
Whole thread Raw
Responses Re: plpython2u not getting any output -> on independent script I get the desired output
List pgsql-general
Hello everybody and thanks for your attention.

I have this function:
###########################################################################################
CREATE OR REPLACE FUNCTION check_current_xlog() RETURNS text                                              
AS                                                                                                                          
$$                                                                                                                          
import subprocess
p = subprocess.Popen("ssh repuser@localhost -p 2000  \"psql -A -t -c 'select pg_current_xlog_location();' template1\" ",shell=True,stdout=subprocess.PIPE)
out,err = p.communicate()                                             
return str(out)
$$
LANGUAGE plpython2u VOLATILE;
###########################################################################################

Problem: I'm not getting any output
select check_current_xlog();
 check_current_xlog
--------------------
 
(1 row)

I checked with plpy.notice(out) and out is empty

 If I execute those instructions in a script like this one
##################################################################################################################################
#!/usr/bin/env python
import subprocess
p = subprocess.Popen("ssh repuser@localhost -p 2000 \"psql -A -t -c 'select pg_current_xlog_location();' template1\" ",shell=True,stdout=subprocess.PIPE)
out,err = p.communicate()
print out
##################################################################################################################################

I get the desired output:
--------------------
F/6CB78FC
-------------------

Any ideas will be highly appreciated. Greetings from Mexico.

pgsql-general by date:

Previous
From: David Johnston
Date:
Subject: Re: Running CREATE only on certain Postgres versions
Next
From: Stuart Bishop
Date:
Subject: Re: Timeline switch problem with streaming replication with 3 nodes