Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 1768C1337B77 for ; Wed, 16 Feb 2011 13:10:30 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 25773-05 for ; Wed, 16 Feb 2011 17:10:22 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sonce.rasca.net (sonce.rasca.net [193.95.206.44]) by mail.postgresql.org (Postfix) with ESMTP id B66B11337B4A for ; Wed, 16 Feb 2011 13:10:22 -0400 (AST) Received: from rokj.rasca.net (rokjw.rasca.net [10.0.0.93]) by sonce.rasca.net (Postfix) with ESMTP id 10B052E027 for ; Wed, 16 Feb 2011 18:08:44 +0100 (CET) Message-ID: <4D5C0569.5020402@rasca.net> Date: Wed, 16 Feb 2011 18:12:09 +0100 From: =?UTF-8?B?Um9rIEpha2xpxI0=?= User-Agent: Mozilla/5.0 (X11; U; Linux i686 (x86_64); en-US; rv:1.9.2.7) Gecko/20100713 Thunderbird/3.1.1 MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: After insert trigger and select Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-5 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201102/84 X-Sequence-Number: 35160 Hi. If I have after insert trigger on some table which updates some data in that same table, will be the select statement from some other client executed after all statements in that trigger? Thank you and kind regards, Rok