Re: Are Triggers Synchronous

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: Shri Shrikumar <shri(at)urbyte(dot)com>
Subject: Re: Are Triggers Synchronous
Date: 2004-02-29 20:17:09
Message-ID: 404248C5.4000603@bigfoot.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Edwin Pauli 2004-02-29 20:42:05 Postgres slow after a couple of days
Previous Message Tony Rice 2004-02-29 19:11:48 dumping fields from Perl