Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id C2EB89FB3E7 for ; Fri, 15 Jun 2007 23:08:15 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 32431-07 for ; Fri, 15 Jun 2007 23:08:15 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from web54302.mail.re2.yahoo.com (web54302.mail.re2.yahoo.com [206.190.49.112]) by postgresql.org (Postfix) with SMTP id 1EAA79FB1ED for ; Fri, 15 Jun 2007 23:08:15 -0300 (ADT) Received: (qmail 25511 invoked by uid 60001); 16 Jun 2007 02:08:13 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=a/rX9gm66rvgWpudO56U9qk6cg0FktuaouCPDehXZx9nJ9EKKlPXNGrn92EwHW1RjsG8/VJkJaVmyhKBQaeUPr8uBIwqaurXoaR+FwKZFrT63fsRNV+WjvsDth8LG5N9MC81aCXtcS3FcJAouPAp/rGOlta2sIBxIGu7OCplMbc=; X-YMail-OSG: QoQrH4sVM1lyL1ApcrtGPXrDv..1t5NEH3wSz8Bwr2sGyIcY1JG6j3VB7LdXUe.8B9EgrASPxp_yrfXJRtOuPjHfevAxVvjvi3hCCHsYW2JzXRlgbS4- Received: from [24.2.63.115] by web54302.mail.re2.yahoo.com via HTTP; Fri, 15 Jun 2007 19:08:13 PDT Date: Fri, 15 Jun 2007 19:08:13 -0700 (PDT) From: chester c young Subject: trigger firing order To: sql pgsql MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <466219.19714.qm@web54302.mail.re2.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/113 X-Sequence-Number: 28603 tables A and B: a post row trigger on A cause updates on B which has its own post row trigger. does the post trigger on A wait until post trigger on B is executed? - this seems intuitive to me. does the post trigger on B wait until the trigger on A has completed? or is post trigger A launched as its own process (in which case who completes first is indeterminate). or am I missing this entirely? pre-row thanks for your insight! ____________________________________________________________________________________ Shape Yahoo! in your own image. Join our Network Research Panel today! http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7