Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VH5Vy-0000TM-Ds for pgsql-sql@arkaria.postgresql.org; Wed, 04 Sep 2013 05:20:26 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VH5Vx-0007gA-Om for pgsql-sql@arkaria.postgresql.org; Wed, 04 Sep 2013 05:20:25 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VH5Vw-0007g3-NS for pgsql-sql@postgresql.org; Wed, 04 Sep 2013 05:20:24 +0000 Received: from woozle.rinet.ru ([195.54.192.68]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VH5Vs-00013N-6S for pgsql-sql@postgresql.org; Wed, 04 Sep 2013 05:20:23 +0000 Received: from localhost (localhost [127.0.0.1]) by woozle.rinet.ru (8.14.5/8.14.5) with ESMTP id r845KIke097724 for ; Wed, 4 Sep 2013 09:20:18 +0400 (MSK) (envelope-from marck@rinet.ru) Date: Wed, 4 Sep 2013 09:20:18 +0400 (MSK) From: Dmitry Morozovsky To: pgsql-sql@postgresql.org Subject: Re: Trigger for updating view with join In-Reply-To: Message-ID: References: User-Agent: Alpine 2.00 (BSF 1167 2008-08-23) X-NCC-RegID: ru.rinet X-OpenPGP-Key-ID: 6B691B03 MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Greylist: Sender IP whitelisted, not delayed by milter-greylist-4.4.3 (woozle.rinet.ru [0.0.0.0]); Wed, 04 Sep 2013 09:20:18 +0400 (MSK) X-Pg-Spam-Score: -1.0 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-sql Precedence: bulk Sender: pgsql-sql-owner@postgresql.org On Wed, 4 Sep 2013, Dmitry Morozovsky wrote: > Dear colleagues, > > I'm running Pg 9.1 and have schema like the following: [snip] > I understand I should use smth like > > create trigger fsl_update instead of insert or update on fsl ... > > but till now did not succeed in it. Quick googlink did not help either. Argh. My google-fu is definitely low in the night ;) for the record: it's right at http://www.postgresql.org/docs/9.1/static/plpgsql-trigger.html example 39-5 Sorry for the noise. -- Sincerely, D.Marck [DM5020, MCK-RIPE, DM3-RIPN] [ FreeBSD committer: marck@FreeBSD.org ] ------------------------------------------------------------------------ *** Dmitry Morozovsky --- D.Marck --- Wild Woozle --- marck@rinet.ru *** ------------------------------------------------------------------------ -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql