Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id BCFD99FB80A for ; Fri, 19 Oct 2007 04:35:27 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 52829-03 for ; Fri, 19 Oct 2007 04:35:24 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id 5E5BE9FA65D for ; Fri, 19 Oct 2007 04:35:27 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.14.1/8.14.1) with ESMTP id l9J7ZO2B059156 for ; Fri, 19 Oct 2007 04:35:24 -0300 (ADT) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.14.1/8.14.1/Submit) id l9J79Lo3034401 for pgsql-admin@postgresql.org; Fri, 19 Oct 2007 04:09:21 -0300 (ADT) (envelope-from news) From: yogesh X-Newsgroups: pgsql.admin Subject: Trigger AFTER UPDATE OR INSERT Date: Fri, 19 Oct 2007 07:09:22 -0000 Organization: http://groups.google.com Lines: 13 Message-ID: <1192777762.618697.226800@e34g2000pro.googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Complaints-To: groups-abuse@google.com User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.2; en-US; rv:1.8.1.8) Gecko/20071008 Firefox/2.0.0.8,gzip(gfe),gzip(gfe) X-HTTP-Via: 1.1 SUMAN1, 1.1 SIFY Complaints-To: groups-abuse@google.com Injection-Info: e34g2000pro.googlegroups.com; posting-host=124.30.27.18; posting-account=ps2QrAMAAAA6_jCuRt2JEIpn5Otqf_w0 To: pgsql-admin@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/189 X-Sequence-Number: 27103 Hello frnds, I have a trigger on a table with After UPDATE OR INSERT ..that insert a record in an another table..........If the Trigger Fire Correctly the row is inserted or updated in the database as the case is. But if it is not fire correctly then the table is also not updated on which the trigger is.............. Is it the right .................? if yes......How to insert the record in the table if the trigger is failed. Regards, Yogesh Arora.