plpython2u not getting any output -> on independent script I get the desired output

Поиск
Список
Период
Сортировка
От ichBinRene
Тема plpython2u not getting any output -> on independent script I get the desired output
Дата
Msg-id CAN_6MJauUdH8pcLbfx=Kwa7RP=E-OuQVigXDqa-VjhERtFWnxQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: plpython2u not getting any output -> on independent script I get the desired output  (Adrian Klaver <adrian.klaver@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: David Johnston
Дата:
Сообщение: Re: Running CREATE only on certain Postgres versions
Следующее
От: Stuart Bishop
Дата:
Сообщение: Re: Timeline switch problem with streaming replication with 3 nodes