Re: Are Triggers Synchronous - Mailing list pgsql-general

From Gaetano Mendola
Subject Re: Are Triggers Synchronous
Date
Msg-id 404248C5.4000603@bigfoot.com
Whole thread Raw
In response to Are Triggers Synchronous  (Shri Shrikumar <shri@urbyte.com>)
List pgsql-general
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.




pgsql-general by date:

Previous
From: Tony Rice
Date:
Subject: dumping fields from Perl
Next
From: Edwin Pauli
Date:
Subject: Postgres slow after a couple of days