Thread: Is it possible to get the return value of trigger function using PHP or any other method.

Hi All,

I would like to put one query which is firing trigger in transactions(Begin,
commit and rollback). If the trigger function success then i have to commit
transaction, if fails i have to rollback.

How can I send return value of trigger function after executing the query.

Is it possible to get the return value of trigger function using PHP or any
other method.

I am using PHP as scripting language, and plpgsql for trigger function.

Regards,
Sreedhar Bhaskararaju 1,2nd Main Road, KottuGardens, Chennai - 600 085 Ph :
4475111 Email : shreedhar@lucidindia.net

Hi All,

I solved my problem, I used begin transactions(begin, commit, rollback)
through PHP when i am calling triggered sql statement. 'Raise Error in
trigger function making result of triggered SQL Statement's return value as
NULL.

Using this value we can take decision whether we can commit or rollback
whole transaction.

Thanks Alot, Let me know is there any other way to do this.

Sreedhar
----- Original Message -----
From: "shreedhar" <shreedhar@lucidindia.net>
To: "Postgres" <pgsql-admin@postgresql.org>
Sent: Saturday, September 14, 2002 9:57 AM
Subject: [ADMIN] Is it possible to get the return value of trigger function
using PHP or any other method.


> Hi All,
>
> I would like to put one query which is firing trigger in
transactions(Begin,
> commit and rollback). If the trigger function success then i have to
commit
> transaction, if fails i have to rollback.
>
> How can I send return value of trigger function after executing the query.
>
> Is it possible to get the return value of trigger function using PHP or
any
> other method.
>
> I am using PHP as scripting language, and plpgsql for trigger function.
>
> Regards,
> Sreedhar Bhaskararaju 1,2nd Main Road, KottuGardens, Chennai - 600 085 Ph
:
> 4475111 Email : shreedhar@lucidindia.net
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly