Re: [GENERAL] Problem with pl/python procedure connecting to the internet

2015-08-23 Thread s d
It might be a dumb thought, but... Did you run the script from ipython as postgres user? External programs called by triggers run as postgres, and maybe your postgres user doesn't have rights to reach the remote service. Regards, Sandor On 23 August 2015 at 09:09, Igor Sosa Mayor wrote: > "Ch

Re: [GENERAL] Problem with pl/python procedure connecting to the internet

2015-08-23 Thread s d
On 23 August 2015 at 18:59, Igor Sosa Mayor wrote: > s d writes: > > > It might be a dumb thought, but... > > thanks. There are not dumb thoughts with such problems... > > > Did you run the script from ipython as postgres user? > > External programs called by tr

Re: [GENERAL] Replacement for Oracle Text

2016-02-19 Thread s d
On 19 February 2016 at 14:19, Bruce Momjian wrote: > On Fri, Feb 19, 2016 at 11:53:26AM +, Simon Riggs wrote: > > On 19 February 2016 at 11:46, Thomas Kellerer > wrote: > > > > Daniel Westermann schrieb am 19.02.2016 um 12:41: > > if I'd need to implement/replace Oracle Text (ww

Re: [GENERAL] Update foreign table with trigger

2016-02-26 Thread s d
On 26 February 2016 at 20:02, Leonardo M. Ramé wrote: > > El 26/02/16 a las 15:55, John R Pierce escribió: > >> On 2/26/2016 10:29 AM, Leonardo M. Ramé wrote: >> >>> Hi, I created a Postgres_FDW table (TABLE_A) and need to do an update on >>> that table. >>> >>> As TABLE_A has a trigger, and the

Re: [GENERAL] Update foreign table with trigger

2016-02-26 Thread s d
On 26 February 2016 at 20:19, Leonardo M. Ramé wrote: > > > El 26/02/16 a las 16:18, s d escribió: > >> >> On 26 February 2016 at 20:02, Leonardo M. Ramé > <mailto:l.r...@griensu.com>> wrote: >> >> >> El 26/02/16 a las 15:55, John

Re: [GENERAL] Update foreign table with trigger

2016-02-26 Thread s d
On 26 February 2016 at 20:42, Leonardo M. Ramé wrote: > > > El 26/02/16 a las 16:33, s d escribió: > >> On 26 February 2016 at 20:19, Leonardo M. Ramé > <mailto:l.r...@griensu.com>> wrote: >> >> >> >> El 26/02/16 a las 16:18, s d e

Re: [GENERAL] Update foreign table with trigger

2016-02-26 Thread s d
On 26 February 2016 at 21:02, Leonardo M. Ramé wrote: > > > El 26/02/16 a las 16:49, s d escribió: > >> On 26 February 2016 at 20:42, Leonardo M. Ramé > <mailto:l.r...@griensu.com>> wrote: >> >> >> >> >> Then try to do the upd

Re: [GENERAL] PLPythonu for production server

2016-03-04 Thread s d
On 4 March 2016 at 10:46, Rémi Cura wrote: > Thanks for the answer guys. > > I should have mentionned that I had read the doc, > and was looking for non explicit knowledge, > like : > - what is the reputation of plpython for a dba? > Dunno. - are there actual production system that use it > I