Re: execute trigger after another one

From: Stephen Cook <sclists(at)gmail(dot)com>
To: Carlos Carcamo <eazyduiz(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: execute trigger after another one
Date: 2014-12-04 23:21:34
Message-ID: 5480EC7E.6080909@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 12/4/2014 6:11 PM, Carlos Carcamo wrote:
> Yes because my update_remote.sh file calls a php file to update a
> table in mysql, and it is updated after I perform another query to
> in_kardex, so the mysql table is one query behind postgres... Any
> thoughts?

My bet is that the query run from your shell script can't see your
changes because the original transaction is still open.

-- Stephen

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2014-12-04 23:31:40 Re: execute trigger after another one
Previous Message Carlos Carcamo 2014-12-04 23:11:15 Re: execute trigger after another one