launch a php script from a trigger function

launch a php script from a trigger function

am 29.03.2010 22:13:07 von Steve.Toutant

Message en plusieurs parties au format MIME
--=_alternative 006F10C3852576F5_=
Content-Type: text/plain; charset="US-ASCII"

Hi,
I have little experience with postgres.
I successfully created a trigger function who does basic stuff such as
UPDATE another table.

Now, I need to launch a php script from that trigger, something like php
test.php.

Is it possible to do that?
thanks
Steve
--=_alternative 006F10C3852576F5_=
Content-Type: text/html; charset="US-ASCII"



Hi,

I have little experience with postgres.

I successfully created a trigger function
who does basic stuff such as UPDATE another table.




Now, I need to launch a php script from
that trigger, something like php test.php.




Is it possible to do that?

thanks

Steve
--=_alternative 006F10C3852576F5_=--

Re: launch a php script from a trigger function

am 30.03.2010 15:20:20 von Steve.Toutant

Message en plusieurs parties au format MIME
--=_alternative 004945FA852576F6_=
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain; charset="ISO-8859-1"

Thanks Randy,
The php script I need to send does not have effect on the transaction. Per =

example I don't need a rollback in the database if the php script fails.

Is it possible to launch a batch file ( ex. test.bat )=20
Steve





Randy Moller =20
29/03/2010 04:42 PM
Veuillez r=E9pondre =E0
randy.moller@comcast.net


A
Steve.Toutant@inspq.qc.ca
cc

Objet
Re: [PHP] launch a php script from a trigger function








It is not possible to execute a script from a database. a php script can=20
be executed by a server daemon or scheduled cron, by cli on a terminal,=20
or, via http (over the web) through a browser. But the php parser does=20
not respond to commands by any database.

Hope this helps.

Randy

Steve.Toutant@inspq.qc.ca wrote:
>
> Hi,
> I have little experience with postgres.
> I successfully created a trigger function who does basic stuff such as=20
> UPDATE another table.
>
> Now, I need to launch a php script from that trigger, something like=20
> php test.php.
>
> Is it possible to do that?
> thanks
> Steve
> ------------------------------------------------------------ ------------
>
>
> No virus found in this incoming message.
> Checked by AVG - www.avg.com=20
> Version: 9.0.791 / Virus Database: 271.1.1/2777 - Release Date: 03/29/10 =

00:32:00
>
>=20





--=_alternative 004945FA852576F6_=
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html; charset="ISO-8859-1"



Thanks Randy,

The php script I need to send does n=
ot
have effect on the transaction. Per example I don't need a rollback in
the database if the php script fails.




Is it possible to launch a batch file
( ex. test.bat )


Steve











Randy Moller <zoom=
erz@comcast.net>


29/03/2010 04:42 PM




Veuillez r=E9pondre =
=E0

randy.moller@comcast.net









A

Steve.Toutant@inspq.qc.ca

cc



Objet

Re: [PHP] launch a php script from a
trigger function


















It is not possible to execute a script from a databa=
se.
a php script can

be executed by a server daemon or scheduled cron, by cli on a terminal,


or, via http (over the web) through a browser. But the php parser does


not respond to commands by any database.



Hope this helps.



Randy



Steve.Toutant@inspq.qc.ca wrote:

>

> Hi,

> I have little experience with postgres.

> I successfully created a trigger function who does basic stuff such
as

> UPDATE another table.

>

> Now, I need to launch a php script from that trigger, something like


> php test.php.

>

> Is it possible to do that?

> thanks

> Steve

> ------------------------------------------------------------ ----------=
--

>

>

> No virus found in this incoming message.

> Checked by AVG - www.avg.com

> Version: 9.0.791 / Virus Database: 271.1.1/2777 - Release Date: 03/29/=
10
00:32:00

>

>  










--=_alternative 004945FA852576F6_=--