Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 5489E9FA2B2 for ; Mon, 23 Jul 2007 18:07: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 40102-08 for ; Mon, 23 Jul 2007 18:07:11 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from BRUBLUmx12.mactelecom.net (BRUBLUmx12.mactelecom.net [217.64.240.4]) by postgresql.org (Postfix) with ESMTP id 083C69F9F73 for ; Mon, 23 Jul 2007 18:07:12 -0300 (ADT) Received: from smtp.eurofer.be (217.64.254.218.mactelecom.net [217.64.254.218]) by BRUBLUmx12.mactelecom.net (Postfix) with ESMTP id 95D5A8380CD for ; Mon, 23 Jul 2007 23:07:08 +0200 (CEST) Received: from ip-80-236-219-14.dsl.scarlet.be ([80.236.219.14] helo=[192.168.1.102]) by smtp.eurofer.be with esmtpsa (TLS-1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.63) (envelope-from ) id 1ID57A-00089d-H0 for pgsql-admin@postgresql.org; Mon, 23 Jul 2007 23:07:08 +0200 Message-ID: <46A51867.2010803@eurofer.be> Date: Mon, 23 Jul 2007 23:06:47 +0200 From: De Leeuw Guy User-Agent: IceDove 1.5.0.10 (X11/20070329) MIME-Version: 1.0 To: pgsql-admin@postgresql.org X-Enigmail-Version: 0.94.2.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Spam_score: -3.8 X-SA-Exim-Connect-IP: 80.236.219.14 X-SA-Exim-Mail-From: G.De_Leeuw@eurofer.be Subject: trigger bugs ? and suggestions X-SA-Exim-Scanned: Yes (on smtp.eurofer.be) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/336 X-Sequence-Number: 26317 Hello all Follow up my previous post and the respons given by Andrew Sullivan, I make a lot of tests and first problem the function _PG_fini are never called it is a bug ?. This is a big problem for me because I want to cleanup the data managed by my trigger. second problem I cannot detect from a trigger the kind of call (row or transaction) I suggest (if it's possible) to add a trigger event like : begin start, begin end copy start copy end or something like that. and finally if the trigger run inside a transaction like copy or begin/end I cannot read the modifications make by my trigger in the same session. it is possible to have a special select like select_uncommited data ? regards Guy