Re: [GENERAL] execute trigger after another one

2014-12-04 Thread Carlos Carcamo
2014-12-04 17:31 GMT-06:00 Adrian Klaver : > On 12/04/2014 03:11 PM, Carlos Carcamo wrote: >> >> 2014-12-04 16:46 GMT-06:00 David G Johnston : >>> >>> Carlos Carcamo wrote I read about oGlenrder of execution of triggers, is supposed that postgres executes triggers in alphabetical ord

Re: [GENERAL] execute trigger after another one

2014-12-04 Thread Adrian Klaver
On 12/04/2014 03:11 PM, Carlos Carcamo wrote: 2014-12-04 16:46 GMT-06:00 David G Johnston : Carlos Carcamo wrote I read about order of execution of triggers, is supposed that postgres executes triggers in alphabetical order, so I called the plpgsql a_trigger and the second one b_trigger (as an

Re: [GENERAL] execute trigger after another one

2014-12-04 Thread Stephen Cook
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

Re: [GENERAL] execute trigger after another one

2014-12-04 Thread Carlos Carcamo
2014-12-04 16:46 GMT-06:00 David G Johnston : > Carlos Carcamo wrote >> I read about order of execution of triggers, is supposed that postgres >> executes triggers in alphabetical order, so I called the plpgsql >> a_trigger and the second one b_trigger (as an example), but it seems >> that the seco

Re: [GENERAL] execute trigger after another one

2014-12-04 Thread David G Johnston
Carlos Carcamo wrote > I read about order of execution of triggers, is supposed that postgres > executes triggers in alphabetical order, so I called the plpgsql > a_trigger and the second one b_trigger (as an example), but it seems > that the second one always executes first. > > Is there any way