ur triggers (including the one above) manipulate rows in different
tables which in turn fire more triggers...
3. If I execute the PL/pgSQL function within Postgres with "\timing" set,
will the returned execution time include the duration of the invoked
triggers?
Kindest regads,
Sebastian
Hi Alban,
Thanks for your response and your time. I added some more explanatory text
in-line.
Kindest Regards,
Sebastian
On Thu, Jul 01, 2010 at 03:10:01PM +0200, Alban Hertroys wrote:
> On 1 Jul 2010, at 12:29, Sebastian Ritter wrote:
>
> > Hi All,
> >
> > I was hopi
ted.
Kindest regards,
Sebastian
--
Sebastian Ritter
Software Manager
sebast...@campbell-lange.net
Campbell-Lange Workshop
www.campbell-lange.net
0207 6311 555
3 Tottenham Street London W1T 2AF
Registered in England No. 04551928
--
Sent via pgsql-general mailing list (pgsql-general@postgresql
Hi Alban,
Thanks again for your response.
On Tue, Jul 06, 2010 at 11:57:14AM +0200, Alban Hertroys wrote:
> On 6 Jul 2010, at 11:33, Sebastian Ritter wrote:
>
> > In what order will the triggers be executed?
> >
> > Will it be:
> >
> > INSERT row
> >
Hi Alban,
I have finally managed to get to the bottom of the problem I was facing.
I thought I'd share my findings, as I managed to waste a lot of time
trying to solve the problem.
As previously mentioned I have several complicated triggers that run after an
insert on a given table. Some of the