Hello,

I need a little help to make a communication between a postgres db
(8.1) and a PHP script. On the postgress I needn't install any kind of
software, so I can only use the pglanguages. My PHP script shares a
soap object, that I can call from the postgres server only via http
(because router acls). I must create a trigger procedure, which calls
the soap object and sends an value of the recordset to the soap
procedure, nothing else.

I have no idea to make this solution. Can anyone help me?

Thanks a lot

Phil

Philipp Kraus <philipp.kraus (AT) flashpixx (DOT) de> wrote:
You will not be able to do this with PL/pgSQL.

Do you have any of the other stored procedure languages available
(PostgreSQL must be compiled with support for them, and
a superuser needs to define them in the database)?

You can use HTTP with PL/Perl and PL/Java, and probably with PL/Python
too (I know nothing about Python).

Yours,
Laurenz Albe

Hi,

On 2007-08-22 09:05:51 +0200, Laurenz Albe <invite (AT) spam (DOT) to.invalid> said:

no, not with PgSQL

I think I will do it with Python, cause it very strange about the
classdesign. If this dosen't work, I will take java. Do you know any
tutorials or howtos? I have written some stored procedures with perl,
but nothing with connection out of the database, so I need a little bit
help

Thanks

Phil

Philipp Kraus <philipp.kraus (AT) flashpixx (DOT) de> wrote:
PL/Perl documentation is available at
http://www.postgresql.org/docs/curre...ic/plperl.html ,
PL/python is documented at
http://www.postgresql.org/docs/curre.../plpython.html .

You will need the "untrusted" versions of the languages because of what
you want to do, so you'll have to create the functions as superuser.

I forgot to mention PL/Tcl if you prefer that.

PL/Java and the others are not in the core distribution, and you would
have to install extra code on the server, which you say you cannot
(see http://www.postgresql.org/docs/curre...ernal-pl.html).

Yours,
Laurenz Albe

On Wed, 22 Aug 2007 08:29:57 +0200, Philipp Kraus wrote:

I have a solution that does exactly what you are trying todo, I have a
postgres database running and a php script to download and insert data in
to the database on a daily basis.
The php script is a basic script I can copy you the relavant parts if you
want it ?

Simon

Hi Simon,

I would be pleased much

Thanks

Phil

On 2007-08-27 12:24:08 +0200, Simon Quantrill <simon.quantrill (AT) gmail (DOT) com> said: