By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,609 Members | 1,119 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,609 IT Pros & Developers. It's quick & easy.

Are Triggers Synchronous

P: n/a
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: 0845 644 4745
I.T. Consultant Edinburgh, Scotland Mob: 0773 980 3499
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-----

Nov 23 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
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.

Nov 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.