Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 3D786476925 for ; Fri, 18 Oct 2002 09:46:17 -0400 (EDT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 3863E476AE2 for ; Fri, 18 Oct 2002 09:46:08 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.5/8.12.5) with ESMTP id g9IDk5hR017009; Fri, 18 Oct 2002 09:46:06 -0400 (EDT) To: =?koi8-r?B?4cvVzM/XIOEu9y4=?= Cc: pgsql-sql@postgresql.org Subject: Re: Can I create working trigger on view In-reply-to: <1702162421.20021018090603@ien.ru> References: <1702162421.20021018090603@ien.ru> Comments: In-reply-to "Acue" message dated "Fri, 18 Oct 2002 09:06:03 +0400" Date: Fri, 18 Oct 2002 09:46:05 -0400 Message-ID: <17008.1034948765@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/209 X-Sequence-Number: 9926 "Acue" writes: > Can I create working trigger on view? Not usefully. No tuple will ever actually be inserted into the view, therefore the trigger will never fire. regards, tom lane