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
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
> >
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 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
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
