Are Triggers Synchronous

[Shri Shrikumar]

Hi All,

I am not sure if this is the right list for this question, so if its
not, I would appreciate a pointer in the right direction.

Anyways, I would like to know if triggers are synchronous in Postgresql.
I have a PHP application and when executing a query, I would like the
queries to wait until the triggers have completed execution before
returning to the application.

Is this possible?

Thanks and best wishes,

Shri

--
------------------------------------------------------------------------
Shri Shrikumar U R Byte Solutions Tel: [phone]
I.T. Consultant Edinburgh, Scotland Mob: [phone]
Web: www.urbyte.com Email: sh**@urbyte.com

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)

iD8DBQBAQhg3BqoC2HdbEIcRAjYLAJwKMxfVdg9qkizqmuc0NL csw7IY+QCfXOXl
Y6qr7vcCiohPxtNmyk4HoCQ=
=psMz
-----END PGP SIGNATURE-----

[Gaetano Mendola]

Shri Shrikumar wrote:

Hi All,

I am not sure if this is the right list for this question, so if its
not, I would appreciate a pointer in the right direction.

Anyways, I would like to know if triggers are synchronous in Postgresql.
I have a PHP application and when executing a query, I would like the
queries to wait until the triggers have completed execution before
returning to the application.

Is this possible?

Of course the trigger are synchronous but you can define it on these
events:

1) INSERT
2) UPDATE
3) DELETE

what you can do with an insert is a RULE instead.

Gaetano.