Re: Trigger for updating view with join

From: Dmitry Morozovsky <marck(at)rinet(dot)ru>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Trigger for updating view with join
Date: 2013-09-04 05:20:18
Message-ID: alpine.BSF.2.00.1309040919030.75311@woozle.rinet.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(at)FreeBSD(dot)org ]
------------------------------------------------------------------------
*** Dmitry Morozovsky --- D.Marck --- Wild Woozle --- marck(at)rinet(dot)ru ***
------------------------------------------------------------------------

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Dmitry Morozovsky 2013-09-04 06:09:17 Re: Trigger for updating view with join
Previous Message Dmitry Morozovsky 2013-09-03 23:38:52 Trigger for updating view with join